Search results

Hi all I have a table in my database which i want to use so that i can amalgamate the data in multiple database (same structure) to this one table. i have links to all the relevant tables in the database and have append queries which take all the data from each of the tables and append them to...

Hi all I have a main form on which i have a subform whose record source is a query which counts records which fall between a start date and an end date. The query works fine if i just use the standard prompts that access provides. Ideally i want the user to enter the two dates into unbound text...

ok, when the two forms are not pop up, i have code that ensures that whenever the 2nd form is opened and then closed again, the initial form remains on a new record. as soon as i changed the form to pop up, the initial form has the first record displayed. Another problem is that there is an...

Hiya Does anyone know why when i have two forms set to non pop up, they both work as they should. as soon as i change them to pop-up forms they do not work properly. as far as i can see the VB code is ran strangley. Was wondering if anyone else has had similar problems. Cheers

Thanks for the reply I may have a look into this method. i got round it by adding another goto New record command just after the msgbox is called. this seems to do the trick Cheers

Hi again Hopefully a simple question. I have a form that has a text entry box and a button. a value is input into the box and the button then clicked. the button brings up another form giving the user the relevant information. the problem is that when the form is closed the first form then...

Thanks Rich I had just spotted the recordcount option just before you replied. Cheers and thanks for your help

Hi all i have a form on which there is a text box which takes in a value. on entering the value the user then clicks on a button which opens another form whose recordsource is the result of a query which takes the previously entered value. i was wondering if there is a way to bring up a message...

One person can have one set of test details. The problems occur when trying to add a new person. once added and the test details button is clicked the test details form comes up blank. This is because the test details table has not had the relevant logbook number entry created in it. If i was to...

I have a problem which i hope someone will know the answer to, its probably really simple. I have a form bound to a table which stores personal details of people, there is a primary key field called "log book number". What i'd like to do is click a button on my form which takes me to a test...

Thanks Mate That worked now. I'll never do that again at least :) Cheers

I have the violation sorted. It was the autonumber field. i still have the problem with adding 14 to the date. i'm not sure where to add this. at present it is as a criteria in the date column on my query. Is this correct sounding or way of the mark Thanks

Ok. When using the select query and taking out the date add field it selects the record i want to modify and displays it fine. its when i turn it to an append query and try without the date query i get an error message regarding a key violation so the record could not be added. Might this have...

Sorry to be a pain but i can't seem to get this. What i've got is an append query which appends data to a "CourseInformationtbl" table. i have added all the fields to the query and set it so that the record that is to be appended is the same as the one on the "CourseInformationFM" by comparing...

Is this however done within an append query. would that work? Thanks

Hi all This hopefully is a simple question. I have a form that books courses. I'd like it so that i can have a button that can be clicked that will take the details from the current record and append them to the table, only it must add 14 days on to the date so the course is booked on a...

Hi all I have a form with a calander on it that i have set up to open a pop up form when a date is clicked. The pop up form shows a continuous form of PC's which have been booked on the date clicked on the calander via use of a query. At the top of the pop up form i am trying to show the date...

It now doesn't matter. i got the problem sorted with the CInt() function. Thanks to the both of you for your help. Cheers

Thanks Pat, i learn something new everyday. Any ideas with regards to where the data types may be wrong with my initial problem. I've changed all i can think of so that they are in the general number form. Thanks

I think it may be the data types but i'm not sure where i can change them. I have changed the format of the NumOnCourse text box so that it is general number and that the capacity column in the location lookup table (location.column(2)) is set to a number data type and is a general number...