Recent content by HelsBels

Sorry, I was being thick, I know what you mean now and that has worked, thank you

Hello I have set up a macro that will run several queries that I have in my database. I also have a form set up. At the top of the form I have a text box where you enter the date that you want to select data for. This is referenced in to each query - so that you need to enter a date in the...

So how do I un-maxmisie it so that it only shows the form as it looks in design view?

Hello Thanks for 2nd option, but when I am in form view I can see the size to fit option in the window menu but it is greyed out. If I go back into design view the size to fit option disappears??

cool thanks.

Hello Very simple problem. I have a form in design view and I can see that it is only 10cm wide. However, when I open it in form view the grey screen goes on all the way to the end of the screen. How do I change the properties so that it only shows what I want it to. I have tried going into...

Hello I have two tables in access. One is the main table, where all the data is stored. The other table is the import table, which is where the data is loaded & updated (records are deduped, suppressed etc.). I am trying to load 300,000 records into the import and main tables. I have a...

Thanks that's worked a treat!

Hello I have 18,000 unique reference numbers in a table that I need to amend. The ref nums are all 16 digits in length and they all start 8243161.... then the rest of the 9 digits are all unique. However, the number 161 needs to be amended to 141. The rest of the number all needs to stay the...

I ended up using the tabbed form option in the last reply with option boxes allocated against each question on the form and it worked really well for me! Didn't end up using the 2nd option with the two tables, got too confused!

Hello I have got a database that has got a few different tables in it. The first table consists of a list of all records with contact names, telephone number, address etc. I have allocated an auto ID number to this field so that it has a unique ref. I have done a few update queries on this...

Forms with option box sorry to revisit this after so long, but I've tried to set this up following the first option that was given to me and I'm getting really confused. My understanding is that I set up 1 table which lists all the questions. But then I don't understand how I create a form...

Thanks - will try the 2nd option, I think that sounds easier.

Hello Sorry, I know it's longwinded but I don't know how else to explain. There are 7 different subject headings and each has about 4 different questions each. I was going to set up 7 different tables and base the form on that. Even though each question is marked with exceed or met, the...

Hello I am having difficulty setting up a form to record quality scores. Originally I had a spreadsheet set up which had a drop down list for each question and then if statements in another cell which would give each question a mark depending on the answer (e.g the drop down list would have...