Search results

It would be best to run the append a couple of times a day. The number of records in total would be in the region of 2600...however, the new records may only be around 5-10 at a time (when the append query is ran). Thanks, -NS

Humm..you might be right! However, is this the correct way to go about it? I'm thinking about how long it would take to do that every time the database is opened! Thanks, -NS

Hey all, I am wondering is there is an easy(ish) way to query a seperate database and then compare it with my database, then only append records that are not already in my database? I'll try an explain this a little better: Database A has records: a b c d My database has records: a b c...

Hey, thanks to the both of you for your replies. I will try and get a screenshot tomorrow, it's very strange! I dont think it's a problem with the fields as it all pulls through on query or with borders as the missing fields are not near the borders (and the fields near the borders display...

Please can anyone help on this? NS

This worked great! Many thanks. NS

Hey all, I have produced a report that when ran produces a pre-formatted report based on a certain criteria. This works perfectly but once I go to print preview it misses random fields out. I don't think it's the borders as the missing fields are sporadic and not near the edge of the page. Any...

Great! Thanks for your help..I shall try this tomorrow :)

Thanks for the quick reply! That seems to be what I am looking for. However, I notice that you have to refer to the control that the restriciton is based on. Unfortunately I dont display the PK on the form...does this matter or can I still refer to the PK even tho it isnt displayed? Thanks, NS

Hey all, Apologies for the cryptic title...i'm not sure if what I want to do has a specific name!! What I have is a continuous form that it based on a query. This form is getting a bit big to fit all the features on one screen now, so what i'd like to do is add a little button (obviously...

Great, thanks! I'm guessing the -1 is the same as Yes and 0 is the same as No? Thanks, NS

Thanks for the code missinglinq! However, I have the fields which the tick boxes are bound to set as Yes/No...will your code still work? Thanks, NS

Thanks. I have just tried this I've found that it's not what I really need. What I now need is two tick boxes (not radio buttons) of which only one can be ticked at one time (but sometimes neither will be ticked...which is why I couldnt use radio buttons) Any help is really appreciated :) NS

Thanks for the reply! Do you know how I would create an option group? Thanks, NS

Hey all, Basically, I have 2 radio buttons A and B. These are bound to 2 fields within my table. What I need then to do is that whenever B is ticked, A shouldn't be and whenever A is ticked, B shouldnt be. In simple terms, only one should be ticked at any one time. This sounds easy but is...

As title really....is this possible? Thanks in advance, -NS

Thanks scooterbug, i'll give that a go tomorrow :) -NS

Hey all, Very simple question probably but my mind has gone blank! ...How do I link a combo box on a form (contains employee number) to a subform on the same form? I.e. I select 12345 from the combo box and only employee 12345's records will be shown in the subform. Also, If possible, I dont...

From memory, I believe Access webforms used to run fine from a shared folder. Does anyone know what format these were? ...and if it would be possible to replicate them by coding them by hand or using a package such as dreamweaver etc?

Many many thanks to MSAccessRookie and Gemma-the-Husky. From gaining what info I could from your replies I have managed to sort this out. My solution seems to be a mix of your 2 replies. It may not be the most well built query but it seems to work :) Thanks again, -NS