Search results

Hi Pat You're right, the Region field is a lookup in the TblStaffDetails. Have you got an example of how I can use joins to obtain the lookup value? Thanks

Thanks for the reply. Yeah, I know it sounds strange. The txtbox on the report is definately sourced to the RegionName and not to RegionID, so it should display the correct values. I can't understand why the qry is ok, but the report isn't. It's a dynamic qry that changes depending upon the...

Hi I have 2 tables in the database I'm currently creating. TblRegion, which stores the region the employee works in, and TblStaffDetails, which stores their contact details. I have the region field in tblStaffDetails, which is a lookup combo box from TblRegion. I have a dynamic report, which...

Thanks for the offer of looking at the database, but I've found a sample at http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb, which does exactly what I'm looking for. Thanks anyway

Hi I am creating a staff database and have a form, with checkboxes, that allows users to select which fields they want to view (firstname, address, etc.) and then only the selected fields are displayed on a form. I am currently using the "Left" property to move the textboxes and labels...

Thanks namliam Do you know if there is any way to do this dynamically? There are about 15 fields that users can choose and I don't want any gaps. I'd like all of the populated colums lines up from the left.

Hi I'm creating a staff database and have a form with option buttons on, which allow users to decide which fields they wish to view. I have used a bit of code on the reports open event, which hides the column if the option button isn't selected, but I need to move the columns so that there...

I've decided to structure the form slightly different. Rather than using a listbox, I'm now using option buttons and with a simple bit of code behind the report, I can only display the headings which are required.

Thanks for the reply. I don't think I've explained the problem properly or maybe I didn't understand the answer. It could be that I'm looking for a mroe complicated answer than I need. The values that are selected from the listbox are the names of the fields in the tblDetails. So, for example...

Hi I am creating a fairly simple staff database in Access 97. The 'tblDetails' holds all of the staff information, such as firstname, surname, intials, address, email_address, etc. I have created a multi-select listbox that allows users to select, which fields they want to view i.e. surname...

Yep, I think it's the space as well. If you don't want 'workstuff' as one word then you can always insert an underscore i.e. work_stuff

In order to get the query to include records on the end date, you need to add '+1' to the query expression i.e. Between [Start Date] And [End Date] +1 Dave

Hi kevmc I'll see if I can help a little bit. First of all it's not a good ideas to have images embedded within Access as it 'bloats' the image and the database will end up very large in no time. It's much better to link the images. In your Employees table you will need a new field which will...

Thanks Ancient One, I hadn't thought of that :o :o

Thanks for the info WayneRyan, that would explain it.

Hi Guys I was hoping someone could give me an explanation of why: 1 - If you use a short date input mask in a textbox and you want to trap Access errors (2113, 2279) you have to use the code on the Form_Error event and not the textbox Before/After_Update event. 2 - If you use a query to find...

I don't think you can change the colour of the whole page. You can change each section by putting the code; me.detail.backcolor = ??? me.header.backcolor=??? etc but this still leaves the magins white. Easiest option is to use coloured paper to print the report out.

No example I'm afraid, but all you have to do is create a form and paste the code behind it. Dave

Hi Merdok I did something similar with a database I created last year. I had a search form - FrmDirectories On the form was a list box, which stored all of the image files within the directory chosen by the user - lstFiles A textbox that stored the path - TxtPath An Image box that displayed...

Instead of using the parameter pop-up box, why use a form? Users can then input info into textboxes and press a cmd button to run the query. Behind the 'onclick' event of the cmd button you can check if all of the details have been entered and display a msgbox if they haven't. Dave