Search results

WOW..that was quick...and remember I am new to access...and this forum has helped greatly! I have the tables joined on the id, but how would I use 2 tables as the record source on the form? or did I miss something

I have my main table that basically holds all my data. I have a second table that I want to hold additional information based on a query run off the first table. The query basically just gives me a grand total for a person, and works fine, I just can't seem to get it populated over to the new...

well SOAB I knew it was easy and maybe just from looking at it so long I missed that... thanks guys, the ac preview works great, not sure what I was thinking

most likely another easy fix that has me stumped. I have a main form with a command button to open a report. Evertything seems to work except that I can't get it it open and display on my cpu, it prints the report directly How do you turn this feature off? currently I have tried different...

this might help to explain the problem a bit better. on the main form with all the records, I have a command button the runs this code: Private Sub cmdUpdate_Click() If [STATUS4] <> "" Then [STATUS5] = [STATUS4] [STATUS-DT5] = [STATUS-DT4] End If If...

I have searched and am unable to find the solution, so if it's posted already, I am sorry. but the problem is that I am trying to use a cmd button on one form to only open certain records from the main form. No problem, except on the main form I have another cmd button that updates from one...

in access click tools>office links>merge it with ms word

in case anyone needs this I thought I'd leave the post, but this works. create you merge field hit shift F9 on the merge field and type { ={mergefield cost \* mergeformat} \# "$#,###.00} where cost is the name of the merge field

I have a merge field in my word doc, and when I merge from access how would you keep the currency format that I need? and I have tried {\# $####,##.00} and it didn't work, with the first bracket before the merge field. Any help would be great.

it turned out to be easier then I thought. I guess I was over thinking it a bit. If anyone needs to code let me know and I can post on here for you.

the term normalization has crossed my desk, would that be inline with flat file system? is it out of line to post the form to maybe better explain what I am trying to accomplish?

I have five text boxes with a separate box for the date that automatically inserts when I enter something in the text box. Is it possible to have it set up to only allow me to enter information in the first box and at a later date when I enter more info in, automatically move everything down to...