Recent content by dodie

Thanks Mr. B! It's all working perfectly now! Thank you so much for your help!

Thanks again Mr. B, I have entered this code exactly as you have said to but I get: Run-time Error '3464' Data type mismatch in criteria expression. When I press debug it takes me into VB and highlights the following in yellow: DoCmd.OpenReport "Training Schedule", acViewPreview, , "ID=...

Hi Mr. B, Thank you for your reply. I have tried this like so DoCmd.OpenReport "Training Schedule", acViewPreview, , "IDTag= '" & Me.ID & "' And have placed it in the OnClick Event of the button, but I am unsure if I have to replace any other code? This is the code on my 'Preview Training...

Hi Everyone, I have a report called 'Training Schedule' and I have a 3 buttons called 'Print Training Schedule', 'Preview Training Schedule' and 'Save Training Schedule'. I would like it if when I pressed these buttons they would do this action but only do it for the current record selected on...

Thankyou all for taking the time to answer, I'm not sure if I'm doing something wrong but when I used your SQL Statements they came up with 'Error#' in the box I'm trying to format. Let's say the field's name is [InstanceDate1]. I have used your suggestions in the Control Source property...

Hi Everyone, Just a short one. I have Multiple Date Fields on a Report that I would like to be formatted as a long date but without the year. Can anyone help? Therefore; Monday, 14th of December. Not; Monday 14th of December 2009. Thankyou in advance.

Hi Galaxiom, Thank you for your lengthy reply. It's greatly appreciated. I understand Primary Keys and Foreign Keys now. The main problem is having it run like I want it to and what best suits the company. The main purpose for this database is so when a company sends me a booking, I can just...

Hi Galaxiom, Thankyou for replying. I have started to make these tables but am unsure about how you make Foreign Key columns... Is this done through lookup columns?

I work for a Driller training company and I have been tasked with making a database to make certain tasks easier. I have not had any training in Microsoft Access, the last time I looked at Access was 13 yrs ago. I have a table called Students which fills in a form called Students. This table is...