Search results

I have a form called frmNon_Compliance, on that form I have a field called Non_Compliance number which is an auto number. The form is linked to tblNon_Compliance. When the user fills in the form and clicks on the button that is called "email report", I have the report based on a query and I have...

Hi I have been reading the recent posts about memo feilds and sizes, missing contect etc, also have researched Google beofre positing here. I can't seem to find what I need to know, well I found half of what i needed. I have a memo field and a text field in tblContract_Clause which stores a...

Hi I'm using the code below to check the form for validation once the user moves to another record or the current record has lost focus. This is doing want i want, except for the staff_Name field. When the message box pops up to indicate that you need to enter a field in Staff_Name and you hit...

Hi I have a field on a form called C_Date and another field on the same form called C_Response_Date. Once I enter a date in C_Date, I have the C_Response_Date populated from the control source =C_Date + 12, which automatically enters a date which is 12 days greater than C_Date. However the...

Hi I have Access 2003 database and trying to import 120,000 rows of data for a properties table from Excel. The Excel book has 4 sheets and I need to import all the data from the 4 sheets into the one table. Access will not allow me to do this. Can anyone suggest a way around this? Thankyou...

Hi Hopefully someone can assist me with this. I have a table and a form. tblAccess & frmAccessDetails The table has many fields, but one is called job_closed. On the form, this field is a combo box with 2 options that the user can select, yes or no. it always defaults to no unless the user...

Hi I have split my DB, FE & BE. The BE is located on a network drive and the FE is located on several local network drives for staff to use. Once I created a password for the BE, the main form would not open for the user on the FE. How can I secure the BE so the data can't be opened...

Hi, I have the following code in my DB. What I would like it to do is attach 2 reports to the one email. You can see one report is attached "rptCST_Access_Request" I would also like to attach "rptCST_Access_Request_Message" to the same email. Any VB Gurus out there that would have a better...

Hi, I have hidden all the menus and added one of my own custom menus to a DB that I was creating. That DB has been completed. Now when I open a blank DB to commence again, I have the same hidden menues and my one custom menu. Is there away in Access 2003 that I can replace the template, for...

Hi Have been working on my DB for some weeks and I'm now at the stage where I'm having a few difficulties that I feel might require code. I'm happy with what I have put together and have been learning lots along the way. Can some assist with these issues, Have a table called tblAccess_Issues...

Hi I went into tools, startup and unchecked allow full menus. Now when I open the DB, I don't have the tools menu so I can check the allow full menus. I need to get this back so I can continue working on the DB. There must be someway to get this back/reverse it. Access 2003 Thankyou Garry

Hi On my main form, I would like to disable the right click so user can't change the form to design view. I checked the properties and could only see allow form view, and that is set to yes. Can anyone help? Garry

Hi When i hit the command button to email a report, a small window appears asking what output would i like to use, Excel, RTF, Snapshot etc. I always want the report to output using snapshot, is there someway I can tell the button once clicked, I would like the output to be snapshot viewer to...

Hi Can some assist with this problem. tblAccessDetails frmAccessDetails I have the above table and form. I use the form to add the data to the table. However I can't add all the data I want for that record, so I need to go back later to continue to add data to the same record. But I need to...

Hi, my first post and I hope someone can assist. I have one combox on my form. When I select a property identification number, I would like the following text boxes on the form to update auto as a result of the property identification being selected. So I need the unit Number, street number...