Search results for query: *

I have a form containing a tab control. Inside one tab is a subform. I'm having a devil of a time getting the subform to fit nicely without scroll bars appearing. One further catch - my subform has a header, detail and footer and I need all to be fully visible with no gaps between them. I...

How get just date part of datetime column in SQL?

MS Access help (what a pathetic thing!) talks about field names and captions but there is no caption property ??? I need the column heads to position automatically based on the column widths.

I have a form with a list box and a FIND button. When this button is pressed it leads the user thru a series of other forms to select records. I build an SQL and want to load it into the rowsource of the original form. I'm using this code but it is not finding the form...

I'm developing what is turning out to be a huge system. My main tables are full of id's which refer to other tables. In my processing I have a constant need to convert these id's to full descriptions. Some of the less voluminous data I keep in global collections. But I have some bigger tables...

I have some continuous forms for editing tables. They always open with only one record showing and I have to drag the bottom border down. How can I get them to open with a greater height so they show more records?

I have set a Default Value for a combo box. The user has made some other selection. Now I need to reset to the default value without specifying it again. How? As usual MS Access help is useless.

Where can I find the code to send Outlook emails from Access. I need to be able to set the 'importance flag' and need to be able to control the 'from' and 'to' emails. I need an example that emails to multiple addresses. Have not been able to find this anywhere. Hope someone can help. MS Access...

INSERT INTO tblTicketPriorityHist (TicketID, Priority, When, User) VALUES( 2, '2', #4/22/2004 8:30:15 AM#, 'dcmcspar') The above statement causes a syntax error when executing VBA but when I paste into a query it runs. I'm using ADO cn.execute statement to run the SQL. Anyone got a clue?

I have to print a report on a record. This record may be pointed to by multiple other records in a different table. I need to list all these other records that point to it, in the report. e.g. Main table: ID = 999 Reference Table: ID = 1 ref = 999 ID = 2 ref = 888 ID = 3 ref = 999 My report...

First can I, and if so how? I have a table full of ID's which are defined in multiple other tables. I need to resolve everything in one query for a report. Any of the ID's may be Null. e.g. Main Table: Client ID - defined in Client table User ID - defined in User table Hardware ID - defined in...

I'm in a tab of a tabbed control in a subform. There is a command button that opens a new form (with docmd.openform)and certain logic builds a string and populates a global variable. I need to get this global variable in a textbox (locked) in the tab above the command button. I do not want to...

I just changed some code and went to compile my database. I'm getting an error 'Method or Data Member not found' on a reference to Me.txtJobStep. The value does exist, its even listed in the prompts when you enter Me. How can I get rid of this bogus error? If I remove that line, the error occurs...

I have a listbox that is for display only. But I need it to allow scrolling. I currently have 'enabled = false' and 'locked = true' and it does not allow scrolling.

All my combo boxes are on a tabbed form in a subform in another tabbed form. Because the subform (and all the combo boxes) are loaded when the main form is opened I left the 'rowsource' blank and dont load my combo boxes until they get the focus. I hope you are with me........ In the onfocus, I...

In the 'on change' event, I need the value BEFORE it changed. How to get it?

I have a tabbed control, within 3 of the tabs I have a subform containing a nested tabbed control (the only reason I use a subform - it is not linked to the main form in any way). The same subform is in each tab and it is formatted depending on which main tab is clicked. But Access insists on me...

How do I add a subform to a tab of a tabbed control ? I've tried this before and it added it to every tab, I only want to add it to one tab

I have a tabbed control, when I open the form that it is in, how do I control which tab is the active tab? Different tabs need to be active under different circumstances.

Im declaring some global variables in a module that is executed at initialization. These variables are not always present and I have no idea why. For instance I set one of them in a form and then when I return to the previous form, the contents have gone. Any ideas? I'm using Access 2000 with...