Search results

Thanks, I'll give that a go just now.

I posted earlier today and despite all of my best efforst I have made very little progress. I keep hitting my head on the desk at the same point. I am trying to get one tool entry to link to many records for each tool. The form [frmVibrationResults] holds tool info, PK is [serial...

I have two mian forms. 1 for general tool info and one for detailed tool info. The detailed tool info has a subform in it which gives details of tool measurments. The link between "General Tool Info" and "Detailed Tool Info" is the tool serial number which I have set as the primary key in both...

Thanks very much

Hello, I have seen pop up calendars in use in other databases and wondered if it was possible to put one into my current DB. (The standard little Microsoft style one). Rather than using a direct entry date field in my form how do I go about adding in a pop up calendar. Can this be done...

I never even knew what the memo option was for, sorry complete newbie. Just changed it and it worked perfectly, thanks for that. Rather embarrased now for such a simple mistake. :)

Hello, I have a text field for filling in details of a job description. I only need a brief suummary, but unfortunately I require more than the standard 255 characters. Is there any way of doings this? I woudl like to be able to add the information to one box in my form as I am cutting and...

Ah ok, thanks very much. Much appreciated.

Got there in the end. Seems to be working now.

Ok, I managed to answer my own question. That was good. However, I'm still doing something wrong, I have changed the record source to my new ubder query and experimented with a couple of fields but I'm still getting the ID number number showing and not the text. I know it must be the way I've...

ID showing on form, NOT text value Hello, I am building a relatively small database, but it is made up of a number of different tables which are fed by other tables. My three main tables are: EmployeeDetails Occupational Risk Profile Health Surveillance Requirements The employee details...

Thanks very much. Sorry, I didn't realise I had double posted. I tried to stop my first message, thought I had.

Hello, Is it possible to get Access to open the print dialogue box instead of printing direct to the default printer when using the print command from a button? Thanks

Hello, Is it possible to get Access to open the print dialogue box instead of printing direct to the default printer when using the print command? Thanks

Hello I am trying to set up a user friendly front end to my database. I would like to have a form which allows the user to enter information into text boxes and then press a button which finds the relevant record(s). I would like to use it to pin point an employee's record based on at least...

Ah ok, thanks very much for your help.

Thanks for the response. I assume you mean use a select query? What do you mean by 'From' and 'Where'? I understand the command, that's fine, but I haven't got it to work yet. I'm not entirely sure how I am supposed to set up the query containing that command. Is it like this: Field -...

Hello, My access skills aren't as good as my Excel skills. I am trying to convert a large uwieldy set of Excel spreadsheets into a more manageable database. Part of my Excel sheets use logical arguments - so they interrogate a cell and if there are two of three results another cell reports...