Search results for query: *

When you entered the new data for your switchboard, did you enter 'Default' in one of the Argument fields?

I'm not sure if I fully understand what you're trying to do yet... (slow on the uptake) Why can't you have the first field as a key linked to a table with the last 2 fields. For example: Selecting a city, that links to a table with country and shipping method? Maybe if you give an example...

Maybe this will help... Private Sub Form_Current() If not isnull(me.LogID) then 'Do all your if statements in here else me.Absorber1Caustic.Enabled = False me.Absorber2Caustic.Enabled = False End If End Sub Q: Why are you assigning the value to null?

Hi Jacal You could try an after_update event for the [departure date] and the [number of last day]. me![return date] = me![departure date] + me![number of last day] Maybe try defaulting [number of last day] to 1?

Hi FeS2 Where does your form get the information to fill in the second 2 fields? Is it based on what the user enters into the first 3 fields?

I'm good thank you AceMan, how 'bout yourself? Thanks for your code but it doesn't seem to work for me. I get the following error: 'The expression you entered has a function name that <Name of Database> can’t find.' And there is definately a function with that name. Cheers for your time anyway.

If anyone is interested, I think I've got a work around for my problem. I've built a function called Status(strStatus as String) with lots and lots of outcomes in a select case. I can use the data in the [Status] Field in the recordset if I go: Status(rst![Status]) But I'm sure there's still...

Hello All, I have a recordset that populates command buttons on a form. This recordset looks up a table that has the following fields: [SwitchboardID],[ItemNumber],[ItemText],[Command],[Argument] and [Status] When the recordset is looping through populating the command buttons I want to run a...

I know this is a late reply, but I've just had the same problem and found a solution. Access the database window (not visible) using Shift key when opening the database or F11 from a non-modal form. Click 'Window' -> 'Tile Windows Horizontally' Hey Presto.

I've had this problem before, I think thread702-318764 might have the answer your looking for.

I had the same problem, here is my solution. It's not pretty but it works. 1. Set the focus to the subform via me.subform 2. Use the code from a delete command button 3. Set the focus back to the trigger Me.frmCredit_Card_Details.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 8, ...

Hello, I have created a database in MS Access 2002, 3 users can access it via Terminal Server. After I use that database splitter and create a front and back end it runs unbelievably slowly. If anyone can help with this it would be greatly appreciated, my dbase knowledge is limited. Lancelotnz