Recent content by MishkaNanook

I have an events database with a description field which I would like to be able to search for multi criteria which would be determined by the user. For example, the user might want to search for all events which are Merchant Navy, Dieppe and Vimy related or they may want to search for only...

Ok I was hoping I was missing something, guess I'll have to figure something else out. Thanks.

Sorry doesn't seem like the attachment is there. Let me try again.

Sorry for the delay in getting back to you, I've been trying to figure out a way to better explain what I'm trying to do and it's not really working so I figured I'd try with an attachement and see if that helps. Exhibit A is what I currently have - a drop down box which gets it's data from...

I know... what can I say I'm having relationship issues, I currently have it set up as a one-to-many relationship; however, this does not allow me to set up a form showing all of the equipment with input fields for Up, Down and Idle.

I'm looking to create a form which allows you to track the amount of time a particular piece of equipment is in use (up), not in use(idle), and being repaired (down) on a daily basis. I currently have it set us that my end users pick's the piece of equipment from a drop down box and then fill...

Sorry not sure what you mean? Form Open event?

I tried that but then it assigns it to the first record in the table and not the new record in the table. I have to get it to a new record first which it doesn't do. Here is what I had Private Sub Form_Load(Cancel As Integer) DoCmd.GoToRecord acNewRec Me.txtUser =...

Hi, I'm trying to ,on loading a form, have it go to a new record and assign a text box called TxtUser the Environ ("USERNAME") value in order to track the user that has added the record. From what I understand the Environ ("USERNAME") will use the network user name which is what I'm...

I managed to figure it out. I had not realized that the default was to bind column 1 were the data I was asking it to sort through was in column 2. Stupid mistake.

Tried to set it up exactly as you mentioned but the query still returns no data which is not right as there is data in the table which matches the criteria.

Yes the form is open, with data in it, yet when you run the query it always returns with no matches.

Good Morning, Can you still use criteria such as; =[Forms]![FormName]![FieldName] in the criteria field of a query in Access 2007 where [FormName] is the name of the form and [FieldName] is an unbound combo box which is pulling its data list from a table. I've used similar...

I have created a database that has both English and French forms feeding information into the same table. I'm not concerned if the info stored in the table is stored in French or in English. It all works fine other then the drop down boxes in the forms, here I only seem to be able to either...