Search results

Hi Amanda - Two ideas come to mind. 1. Write some VBA code to do this It looks like the order of the records is important: e.g. all the items after DMA Albany should "remember" that field until the next DMA item. A VBA procedure could scan through the records in order and build the...

Okay, I was able to take a look at the db. 1. When you click on the Edit button, you see the site info tab. All the fields that are displayed here belong to whichever record is displayed (usually the first one). 2. So, if you are looking at the first record and you change any of the...

Sorry that it is still giving you problems. See attached for a simple example. Probably something is different between this and yours, however, otherwise you would have been able to get this to work already. The SQL statement looks like this: SELECT tblPurchaseOrders.PurchaseOrder...

Sorry, didn't realize that you had so much data to manipulate. DLOOKUP is sort of convenient for small uses, but it is not particularly fast. I would try the approach in VBA. I think with the data sorted correctly (first by policy, then by transdate), you could make a single pass through the...

Hi Jeff - Sounds a little like the approach by compilers to "tokenize" a program (convert the lines of a program into language tokens that are recognized by the compiler as instructions). I would store the tokens in a table or array and use InStr to see if there are any matches. You could do...

Hi - Here's an idea, maybe this works or not - For each policy, sort the transaction dates. Then match each date with the next greatest date (this can be done in a query). The duration will be the difference between these matched pairs. (The last date will not have a matched pair, but that...

The general approach is this - 1. Start with your combo box on the form. 2. Overlay a text box on the display part of the combo box. I.e. the text box covers the area of the combo box where text is displayed, but not the pull down square. 3. The OnEnter event for the text box is set to...

Hi - You can set the RecordSource property programmtically with a valid SQL string. E.g. Me.RecordSource = "SELECT * FROM tblData WHERE DateEntered > #1/1/2000# " You can test the SQL string in a query to see that it is working correctly as part of your debugging. Hope that helps, - g

Hi - and welcome! When you say "page" do you mean you have continuous forms or continuous subforms? Or do you have different tabs set on a single form? Is the Market Segment combo box bound to a table field? If you are using an unbound combo box on continuous forms/subforms then I may have...

Hi Dan - Try something along these lines: SELECT tblBooking.ID, tblEvent.Event_Name, tblDelegate.Delegate_Name FROM (tblBooking INNER JOIN tblDelegate ON tblBooking.Delegate_ID = tblDelegate.ID) INNER JOIN tblEvent ON tblBooking.Event_ID = tblEvent.ID; I usually find it easiest to start...

Sure, I can try to help - but can you re-post as a new thread so that others can "tune in"? Also, I think that I am understanding your question, but please clarify: What does the Program ID connect to - your tasks? What specifically do you think won't work for the new month? Thanks!

Great - glad that it worked!

Thanks, Shadow. That's the other thing I was trying to remember.

Hi Steve - Not sure that I have a good handle on this, but I'll throw my two cents in. The error message is occurring when you try to update the Master field on the main form. Part of the issue, I believe, is that the main form doesn't have an associated recordsource, so the field [Group1]...

Good Job! Great, glad that you got it figured out! You must have had a filter on that was eliminating all the records. Thanks for letting me know, I had not thought about that possibility. Feel free to post other questions about validation rules, although please start a new thread so that...

Hi - You can pass a parameter to a query by entering a prompt in the design view. E.g. where you normally put the PO number, put the following (including the brackets). [Enter PO] When you open the query, you should get a message box that says "Enter PO". This should work with either a...

Hi jon - My guess is that the button works on a previously entered record, but not on a new one. If so, then what you are seeing is the fact that Access doesn't actually write a new record until you move to another record, or close the form. You could do something like: DoCmd.Close acForm...

Hi - Not clear if I fully understand the question, but I'll try to help. Are you really trying to merge records (data) from db A, or fields (table structure)? What exactly are you bringing in from dbA? (A single table? multiple tables?). Can you post a simplified db that illustrates the...

Hi - welcome! Sounds like a frustrating problem. Try the following. Open the form in design view. At the upper left, there should be a small box with a black square in it. Double click the black square. This should open another window with the form properties. You should see the following...

Hi - I think your syntax is not correct. Try replacing the AND with a comma (assuming that you want to update two fields vs. match two fields ) sql = "UPDATE CONSTRUCTIEF SET ConstructiefScore = " & strGebouwConsScore & " , ConstructiefCommentaar = '" & strGebouwConsOmschrijving & "' WHERE...