Search results

Wow. I was going to ask for more detail, but you've done it for me :) Thanks!

I don't think you can put them on a report, but you could always make a custom toolbar, or have a small non-maximised form open automatically as a toolbar-equivalent.

Well if you delete records, the autonumber carries on from where it got to, not from the last existing record. Have you deleted ~2000 records?

(I did serach for past topics, & found one, but the solution pointed to a link that doesn't work; sorry...) I have a database (well, a half-database at the moment) which is used to book a hall. I want to add a calendar to the bookings form, so users can see what they're doing more easily. This...

Thanks; that's very helpful :D

Is there any way I can 'grey-out' (not allowing people to type is the most importent thing here, but the turning grey would be useful too) a field if (for example) a check-box isn't selected?

Sorry; didn't explain too well. I'm worried about the retrieval time. ...but I've just realised none of this matters; I overlooked a (totally unrelated) problem which means that I need a quick re-design anyway. Too complicated for me to bother explaining... Thanks for trying to help!

If I have a tab control in a form, with a form on each tab, will the data from all the tab's forms have to be loaded when I open the 'host' (don't know what to call it) form? I can't tell if the load time is increased, as there isn't much data there yet, so it's pretty much instant anyway...

Ah, thankyou. I didn't know that was there (never used a linked external table before). Thankyouverymuch!

I have a database which contains a link to an external table. This link is broken, however, if the external table's database is moved (yes, I know this isn't a suprise). What I want to know is if there's a way that would be easy for a user who's not very confident to easily change the path to...

Duh! Duh! Duh! Sorry, the answer was shouting me in the face. What I was trying to achieve with this query is exactly what is achieved by a filter...sorry!

I currently have a query which takes its criteria from a form called search. This all works fine, unless the user leaves a field in the search form blank. Then the query has no results. What I'd like is for a blank field to act as a wildcard. I guess the reason this doesn't automatically work is...

Aha! Solved! I simply deleted the 'key' field in the COMPANY table, and made 'Code' the primary key (as they are always unique anyway), and the made the combo box refer to the 'Code' field. ThankyouThankyouThankyou! :)

Aha! I'm getting closer! Thanks! Yes, the query now works, but now the user must enter the relevant 'key' (an autonumber field in the COMPANY table) rather than the company itself...any way I can stop that?

Thanks for the quick reply! (Yes, I know that the form must be open) Here's a screenshot of the combo's properties:

Well I tried re-making my query, but it didn't help. Let me explain a bit more, to make it easier for someone to help: Form: TXNS By Company DIAG: There is no key field--not data is actually entered There needs to be one field (currently a combo box: 'Combo0') where users enter a compnay code...

Yes, I tried that, but then my queries don't work. Hold on, I've just thought...(a miracle)...I'll probably need to remake my queries referring to the field wich is changed to combo-box...I'll try it. Thanks

oh...I hate new worlds. But thanks anayway!

I want to use a macro for validation on a field on a form. I don't want users to be able to enter a company code that does not exist in the COMPANY Form. The condition I've got is: [Forms]![TXNS By Company DIAG]![Code]<>[Forms]![COMPANY]![CODE] The problem is that this only works if the COMPANY...

Oh. OK. Thanks!