I am using the following code to open a cmd window and wait while it executes, but I would like to run the cmd window minimized but cannot work out how to do that
Code:
Option Compare Database
Option Explicit
Private Type STARTUPINFO
cb As Long
lpReserved As String
lpDesktop As String
lpTitle As String
dwX As Long
dwY As Long
dwXSize As Long
In my current database there seems to be two different types of borders in my pop-up forms! The best way to explain it is that some forms will have the Access style border while others have the glass style border that you see in windows. I can't seem to find any settings that will change this or even determine what causes it.
I'm running MS Access 2003. My SQL editing window has a really small font size. How do I change this window's default font size? Is it in tools or options?
Help!!!!!!! I'm going blind!!!!!!:confused:
Thank you for taking the time to read this and for being willing to help out!!
I am trying to create VBA code (I have very little experience of VBA) to recreate a parameter query mail merge, which Access 2013 cannot achieve with the controls provided.I think that I need to assign a variable to the value of a control on my form then assign that variable to the relevant criteria section of my query.
Code: DIM RefNo as String DIM IDNo as String RefNo = Me.[Reference Number].Value IDNo = Me.Text582.Value DoCmd.OpenQuery SORTER How do you paste into criteria?
From there I would like to do a Word Mail Merge by having VBA open a document in Word, then activate the Merge to a New Document instruction.
I have created a form that will print the active report. I have managed to make it look for the active report, but it won't find it because there's no report active, even though I have the report open. How do I make my report be active when I open it? (In a way that whichever report I open will become the active window so that my form will e-mail the report that is currently open)
I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.
How does one pass argument back from child window to parent window?
From parent window to child window, I used docmd.openform ,,,,,,[argument] and me.openargs in the child window
Is there a command that I can use to export a spreadsheet to Excel...
I could use docmd.transferspreadsheet
however that would also mean i would need an input window where users would need to manually put in the location they wish to save to...
Instead, could i not get a "SaveAs" command window or a file browser at least for them to search that way? Alternatively, If it was possible to use VBA to pop up the "Export - Excel Spreadsheet" window, that would be just as good.
I am new to VBA for access. I am working on a form as a user interface. I have added an picture to the form and it will change, according to the selection in the combobox. It looks small, and not clear because of the size, and each image has different size. I would like to know if there is a VBA code that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes.
Who can tell me how to minimize Access window while it's form is on top of other open windows (e.g. other applications which are maximized like Excel). By using acCmdAppMinimize command, only the Access window is minimized and if other applications are maxmized, they will be on top. So is there any vba solution to do what I explained?
I've tried to add some basic login (not really security) to my database so that when a different name is entered into the login box a different form is opened.
I got this working but the login form stays in foreground and I can't click anything behind it and can't get to the design view to change any properties of anything.
I've also changed this login form to the startup item so it always loads when i start the database.
Is there way to get back to the design view or do i have to start again from my backup?
I need a help. I would like to (if possible) to place into Form an object that could create a Tree-like menu structure. The source from this object should be table/query. Is this possible?
I am not sure how to search the forum for info on this issue as I don't know the key words (Lingo) that would be used, so I decided to just ask...
I have a table called tblProducts with a one to many relationship with a table called tblTransactions.
I also have a paper form, much like a grocery list, that has known types of products to purchased on the top have and the bottom half has blank line to enter products purchased that are not listed above (or are unknown). The list is much larger and takes up more than one sheet of paper, but is done on a weekly basis. Here is a short "Grocery list" style example:
Date:_________ . Description....Qty...........Description...Qty Ice Cream:....................Milk: ....Vanilla......___Gal...........Whole......___Ga l. ....Chocolate..___Gal...........2%.........___Gal. .......................................Nonfat...._ __Gal. Bananas........___Ea. ..................................Meat: Bread:..............................Pork.......___ lb. ..White.......___Loafs..........Beef.......___lb. ..Wheat......___Loafs..........Chicken....___lb. . ---------------------------------------------------- ____________ ___ ___........____________ ___ ___ ____________ ___ ___........____________ ___ ___ ____________ ___ ___........____________ ___ ___ ____________ ___ ___........____________ ___ ___ . I want to create a form that you can enter data into exactly like this and have the data find the product in tblProducts and then create a new transaction for that product in tblTransactions. If the product is new, then it would create a new product and the transaction. The date also has to be entered into each transaction, and most times the data is entered weeks after the paper is filled out, so using "today's" date won't work, it has to read it from the entered data.
Any help or direction would be greatly appreciated. I haven't been able to find anyone else doing this, but then I may not be searching with the right key words, as I don't know what you call this type of data entry.
How do I copy a form from one database that have reports and quaries linked to it to another so that I can change the information in the new database and keep the form style in the old database?
I want to synchronize 2 comboboxes (actually 3, but let's start with 2)
On a form I have 2 comboboxes:
- CompanyType (FK fkCompanyTypeID in table Contacts) - Category (FK fkCompanyCategoryID in table Contacts)
Let's say we have companytype CT1 until CT10.
For CT1, CT2 & CT3 I want to choose a catagory, so the combobox must be 'enabled'.
For CT4 until CT10 the Catagory combobox must be disabled, so that I cannot choose a category value.
Actually I want to choose 2 catgories (2 comboboxes) for CT1 until CT3. But I think that an explanation for the example above is sufficient for me.
Both comboboxes are filled by a Select Query, and the values are filled in a separate table. (Table CompanyType (PK pkCompanyTypeID) & Table CompanyCategory (PK pkCompanyCategoryID)).
Can someone please help me on this issue? :confused:
In the subform i have the layout i want with the text boxes and so on.
Now i have that in the main form the sub form is fairly big, but the problem i get is the subform only displays 1 record at a time. Is there a way i can get the subform to display all the records and for it just to add a verticle scroll bar.
does anyone know how I can get the Windows XP style command buttons to work in Access 2000? I'm on an actual XP pro machine and I'm sure there's an active x control somewhere... just don't know where to look
I am in the process of re-writing an Access system that was created with 100% macros. I need to convert the custom menus that were created with macros to vb code. I tried to convert the code to modules, but I can tell that is not the path. Does anyone have a simple example? For instance, the first custom menu is just File, Exit.
hi there , i am trying to populate a drop down list using a 3 tier style 1 will be the class.vb , next webservice.asmx , next is the webform currently i am having some problems with the coding
<code> //class1.vb PublicFunction getBanquetProvider() cnn.Open Dim strSql As String = "SELECT DISTINCT Company FROM Banquet" Dim cmd As New OleDbCommand(strSql, cnn) Dim da As New OleDbDataAdapter(cmd) Dim ds As New DataSet Return da.Fill(ds) cnn.Close()
Hi ,I have to make some specific records in a table in bold.Can any body suggest me how to make a particular record in bold or set some color fonts in order to high light the record. I have to design a report which shows some priority records with different font style in ms access
Hello all - Working on a form that is supposed to display order approval information. In the database I'm working with, people are stored as in the approvals table by a reference to an autonumbered value. However, I want to display their name, which can be obtained normally through an SQL or DLookUp Command. This tabular form style though is giving me a problem. If I put new textboxes on the form and load it as I normally would, like:
*ApprovalID is a hidden textbox that stores the number that is used to represent a particular user.
The problem becomes that using an OnLoad or and OnCurrent Form function, the boxes only load one value. I want them to load the different values for the different entries, but I am lost as to how to do this. Any help would be appreciated.
A similar issue that I've been having with reports is that I don't know how I would do this at all... I want to do the same thing (retrieve the Name or whatever that is related to a numerical value) and put it on the report. I'd appreciate any info on how to do this.
