Search results

Thanks for this, I have used a look up for a more complex example of this, but the lookup in question only contains 5 items so I didn't think it would warrant a table of it's own.

I am changing various information, for instance I have a lookup field in which I require to add additional choices. After adding these in the table, I have to re-insert the field on the form. I'm just looking for a quick refresh trick in order to avoid this.

I always find that if I update a field in a table, I have to then re-insert the field on the form it sits on in order for the changes to be pulled through. Does anyone know of a kinda 'refresh' that I can do which will save me the time of having to re-insert fields on the form? Thanks

I realise my error now. I actually needed less than today's date to see the 'overdue' tasks, ie Is Null Or <=Date() That works! ;-)

I got a "Data type mismatch in criteria expression" error.

I would like a query to return all the records in which a field [Date Required] is equal to or greater than today. I have put in the [Date Required] criteria >Date() but this doesn't seem to work. Any suggestions?

Thanks Sue, but I've check the form footer and the bottom of the 'detail' section is right up to the last field. Any other suggestions?

I have a form which has about an inch of white space at the bottom. Not normally a problem, but as I wish to display the default record selectors it is causing a vertical scroll bar to be displayed. This means the user will have to scroll down the form, when there does acutally appear to be...

The code reads: Private Sub next_Click() On Error GoTo Err_next_Click DoCmd.GoToRecord , , acNext Exit_next_Click: Exit Sub Err_next_Click: MsgBox Err.Description Resume Exit_next_Click End Sub

I am presented with the attached error when I create a command button. The strange thing is I have other dbases running command buttons which appear to be working fine. Any ideas?

As you can see from the attached capture, they are joined by equal fields. I have a identifier field which joins each of the tables. Any suggestions?

I have a dbase which consists of three tables all linked. I have created a query which pulls various fields from each of these tables. tblobjective tbltask tbldates On some occasions there may not be any data in the tbldates, but there could be in tblobjectives and tbltasks. My query doesn't...

Yes but... I realise if you minimise the dbase window then Access automatically sets it to be minimised on open. But what if the user 'forgets' to minimise on close.... is there someway we can force the dbase to minimise the dbase window? I thought about putting the code in the On Close...

Helpful Thanks that was very helpful - I've converted down, but your are right I've lost features :mad: Getting a "Compile error: Method or data member not found". This is becoming a lot of effort for what should be a simple task. I think I'll use my friends laptop and give up!

Convert down? How do I 'convert down to 97' ?

Can anyone advise if it is possible to save a 2000 dbase as a 97 version? I have created a dbase using 2000 on my work's network and I want to open this dbase on a laptop which only has 97 on it. It's not my laptop otherwise I would do the obvious and upgrade it to 2000!

Simple?? Hey 'dspinner' - it's only 'simple' if you know how it's done!! Sometimes it's these 'simple' problems that take up the most time. Thanks for placing this post, cos I had exactly the same question, but didn't need to ask cos you already had! And thanks to 'DBL' for the answer :)

Thank You A big thanks to Jack for his advice, the dbase is now under construction!!

This is a general query about the structure of my database, albeit a fairly simple one! I have records which hold a name, date and then a selection of various topics. I need to be able to run a query to select a topic and then to report on what name and date contains that topic. I've set up a...

I would like to have a field which is a unique identifier. I'm aware if I use the AutoNumber Data Type in a table I will be given a new number for each record. But I would like to pre-fix this number with a letter, ie LEA1, LEA2, LEA3.... Can anyone advise? Thanks.