Search results

Thanks, worked a charm. Seemed so much more complicated before.

Hi, Is there anyway to pass a value from a textbox on a form to the report that prompts the user (and auto-submits if possible). So i have a textbox called txtID with value 23 When i press a button, the report opens up and 23 is shown in the prompt. Thanks in advance.

I'm going to be honest...it didn't cross my mind to use double. However, it does miss out the 0 at the start. DCrake, i wasn't aware of the access formula Nz(). Thanks for that.

Hi, Thanks for the reply. That worked nicely. Just for the info: It is a textfield. the reason being a number field for mobile number is too large for the field in access.

Hi, i keep getting the error displayed in the title. I ma doing a pretty simple query. Just finding a value in one table and inserting it into another. Does someone know why access does not like it please?

Did it, it was just me. not me! but i had to use a button and not a hyperlink.

Thanks for the reply but that doesn't work. If i have multiple rows, i would like the view details chosen in that row to get the uniquevalue of that row. Attached is an image that may help. so say for the second item, if i selected view results i should get h28288.

Hi, i have a form with a hyperlink that goes to another form. I pass a variable when the user clicks on this link. My issue is, if i have multiple results, and i click on the link, the system only seems to find the first item. e.g results Date Item Link...

Hi, i have a simple query but for some reason it's not working. Let me get to the point. 2 tables - table1(id,txtfield1) table2(userid, idfield) idfield contains id so foreign key (although hasnt been set up as that yet) Aim: select all fields from table1 where table2 doesn't contain them...

It's ok i worked it out

How? The report wizard doesn't allow you to create labels. Or even a label layout. I need 2x8 2 labels across and 8 labels down. How do i do that?

Hi, How can i send data to labels in word as a mail merge?

I adjusted the report. Added clerk and picture from clerk table. I said where clerk.clerk = 15letters.clerk and it worked. cheers

A little problem [RESOLVED] I have tables- 15letters, clerk, and i have a report. Clerk contains, a name and an associated picture. 15letters also contains clerk. In my report, i have the main details from 15Letters, along with the picture from clerk. This report was already set up so i...

Hi, i'm new here. My database contains a table from which the report is generated. Then in another table there are signiture pictures. Table a (report table) links to table b via clerk. I want to show the picture matching the clerk in the report. e.g if the report shows clerk 'fred' then...