Search results for query: *

Hi, I'm trying to write a code that: 1- Uses DLookup to find a value based on a criteria (which happens to be the primary key) 2- Check if this value is null, and 3- If it is, insert a value into a table from a textbox on a form. The thing is, the table is already created, so I'm not adding...

Hi, I attached a report to a query that has selection criteria, so that when you open the report, it prompts you to enter in values (ex. a month). I followed the steps in Access Help ("Use a form to enter report criteria"). Everything works fine, but the system now pops up its own message box...

Hi, I'm trying to concatenate two Time fields in a query. Sometimes the second field will be null, so I wrote: (the lengths are associated with a MasterName) Duration: Format([tblMasterNames.Length],"Short Time") & ("/"+Format([tblMasterNames_1.Length],"Short Time")) and in SQL...

Hi, I have three tables in a query - tblFullName, tblHalf, tblHalf_1 . tblHalf and tblHalf_1 are identical. In tblFullName, there are columns: FullName, HalfName1, HalfName2. I'm trying to link HalfName1 to its corresponding column in tblHalf, and HalfName2 to its corresponding column in...

Hello, I made an option group ToggleFrame with 4 buttons, and wrote code so that when a button was pressed, it would change the row source of a combo box Combo1. The problem is, I think, that the combo box is on a subform (Sub_Form), while the option group is on the main form. I did it like...

Hi, I'm working with a combo box on a form that draws its values (EDates and Events) from a table. Currently, it stores the Event name. I would like to set it up so that if the Event has already passed ( EDate >Date() ), then the Event name turns red. Because the EDate of the event isn't the...

Hi, I have two text boxes in my form, "boxWeekBegins" and "boxWeekEnds." I'm trying to make boxWeekEnds default to =[boxWeekBegins]+6, by putting this in the Properties-> Data -> Default Value space, but for some reason, when I open the form and enter a value in for boxWeekBegins, boxWeekEnds...

Hi, I'm very new to VBA and I was hoping someone could help: I'm running a For Each loop through values stored in the temporary table (working) and storing them into a permanent table (tblTrafficForForm). The working table is populated from the form, and three columns (open, close, and...

Hi, I have a multiselect list box in a form, with a loop on the After Update() event to write all selected values to the table. However, each time the old record loses focus, the form enters a blank record onto the table. Also, I don't know if this is important, but when I check the datasheet...

Hi, I'm trying to create a loop that will write the values selected from an extended multiselect list box to a table. Table = TrafficForForm Market = column in the table to be populated lstMarket = the multiselect list box The commented out lines are ones I think might be wrong or unecessary...

Hello, I'm working on a form-subform combination, where the main form is a date, and the subform is a list of events. Both are supposed to write to the same table. When the subform is a list box where only one value can be selected, everything works. However, I need the subform to be an...

I'm trying to develop the following form-subform system: Main form: a list of markets Subform: several records of details about a market The problem is that many markets will have exactly the same details associated with them, though some will not. Further, the markets that are identical for...