Search results

Not directly - a combo box can only be linked to one field. However, you could use the AfterUpdate event to update the 2nd field or another control on your form linked to the 2nd field and accomplish the same thing. I am wondering why you would want to do this...?

A linked table in Access essentially functions as an actual table. The SQL is running against the table (linked or not) listed as your SearchTble variable. Whether or not it is linked should not be an issue. (This assumes that 'SearchTble' is a variable - that's what it looks like it is) [This...

You need to have your locations in another table linked to the client. Then, show the locations with a subform (which will show all locations for the client displayed in the main form). If you add a location to the subform, it will link to the main form client.

You need to have that information in a number field, not a text field. A text field sorts by the first character, meaning 700 comes before 80 (because 7 comes before 8). A numeric field looks at the actual number and would sort it appropriately.

What is your starting value? How many rows do you want? Are you filling in values for records that already exist, or creating new ones? I have to admit I don't quite get why you would want to do something like that. Let me know and maybe something will come to me!

You would just set the string to it. Dim YourSQL As String YourSQL = "[Request Date] BETWEEN (DateAdd("ww", -1, Forms![Weekly Summary]![cboWeek])) AND Forms![Weekly Summary]![cboWeek]" Then call it this way: [Forms]![Weekly Summary].RecordSource = "SELECT * FROM [YourTableName] WHERE " &...

I wish there was some reference to say "If you want to use this command, you need this dll referenced." Haven't found it yet. I generally just play hit and miss to get the reference I want. Here are a couple more that I have that may fix the FindFirst problem: OLE Automation Microsoft Visual...

How about using VBA to loop through your records and multiply each successive value?

Let me give you two options. There are probably more: 1. Have the "sub" forms be pop-up forms that open on the Command Button click. You can then use the "Where" clause of DoCmd.OpenForm to dictate which records should appear, making it behave like a subform. 2. On my main form, I have a...

It likely has to do with the References (Tools-References in VBA). Check off the following: Microsoft DAO 3.6 Object Library Microsoft VBScript Regular Expressions What is happening is that you are telling to make the variable 'db' a 'Database' but it doesn't know what a 'Database' is unless...

To get the e-mail to send without editing, it is one of the last variables for the SendObject function. Look at SendObject under help files (I don't have Access in front of me or I would give you the exact code). To add a line to the e-mail, put the following in your text: "This would go on...

Where did you put the code? For which event on which control? It sounds like you are not at all familiar with VBA. I would encourage you to look through the help files, this forum and others to learn a little more about it.

I am assuming that you have some way of deriving the subset of quadrants that match what you are looking for (a query perhaps). In the AfterUpdate event of when you enter the data in the form, simply put If Me.Quadrant = Your Criterion Then MsgBox "It meets the criteria." or Dim db As...

Something in me just needs to express the disclaimer that I don't think this is the best way to manage your information. (*Whew* - now that that's off my chest...) You would put a field in the intake table called "DateToMove" (or something like that) and place your date there. You would...

It is possible to keep the information separate, and upon a certain event, move them to the master table and delete them from the intake table. You could do this with append and delete queries or through VBA. However, I would recommend putting all of the info in the same table and simply...

Are there records in the master table that are NOT in the intake table? If so, how did they get there? It sounds to me like all of your information should be in the intake table (which would then become your "master table"). There is never any reason to store the same information in two...

What you are asking is possible, but sounds like poor database structure. Why have the intake table? If the information is in the Master Table (or should be), why not just extract that information from the master table?

Check this page for information.

Putting the code in the after update event wouldn't work because after it updates, the OldValue is the same as the control. What I ended up having to do was record the OldValue in a variable and have another variable in the BeforeUpdate event tell whether the data is to be changed back. Then...

I am getting a confusing message with this. I have a field that is a combobox on the form. I want to, under certain conditions, "undo" what the user has done (you will see what I mean in the code). When I run this, I get the following error message: RunTime 2115: The Macro or Function set to...