Recent content by amycclark

I think it was a marco issue. Thanks for the replies. I originally copied and pasted a form that was similar (trying to be efficient) and I think that form had some macros in it causing me a headache. :banghead: I ended up starting from scratch and all was fine. :D Thanks again! ~Amy

I have a form with text boxes and after I click on the text box, the field gets grayed out. I can still read my text but I would rather it have it stay white. Any suggestions??? ~Amy MS Access 2010

I figured it out.... my form was still pointing to table rather than a query that combined the tables. doh!

Thanks for the reply. I have Access2010 and I should have been more specific... I have a combobox added but I can't get it to show the values of interest.

having trouble selecting a record to display on my form. I have two tables [tblMain] and [tblPrjName] [tblMain] contains an [id] and lots of information I want to display on my form. [tblPrjName] contains the [id] and [ProjectName] [id] is a unique value (i.e., no duplicates). I want to...

This works perfectly! Thank you so much for taking the time to show me the details too. Thanks Nigel!!!!!!!!

OK, here's what I came up with this morning.... it isn't working but I thought I would toss it out there to see if I should really abandon this atempt. Clearly I am not a programer. But any comments are appreciated. Thoughts as to why this does not work?: Dim YEAR_COUNT As Integer...

Paul, sorry missed your previous message. I cannot have duplicates! :) Meaning... if I had two projects that came in on the same day, the first one entered would be 006 and the next one entered would be 007.

I feel I really do need to supply a number to them. This number becomes the "file number" for the project and is the main number used on all our commpunications, etc. So I don't see a way around that. So since 1987 or there abouts the user goes in to the table first, looks to see what the...

I could have the user add "drp 14-" themselves then when they hit enter... how would I get Access to count the number of records with "14" in the [DPRNO] then append that number (+1) to the end of it? So that I still end up with "drp 14-###". I should state that this is an existing database...

I have a form [IUDATA] I have a add record button. I have a date field [DATEIN] I have a text field [DRPNO] If the [DPRNO] field is empty, I would like the user to have the [DPRNO] field be automatically populated after the user enters a date. I'd like the format of [DPRNO] to be "dpr...

You got it David. Goverement work. ;)

oooh.... I fixed it myself by adding acViewPreview If you only knew how proud I am of myself for this one thing! lol! Thanks a bunch! Private Sub OpenRptSingle_Click() On Error GoTo Err_OpenRptSingle_Click DoCmd.OpenReport "Enforcement Report", acViewPreview, , "Facility = '" &...

Well thanks Pauls! I am getting close... I pasted below my code revisions... I added the & and single quotes, just as you initially said so now it runs but doesn't open the form, it prints it! oy. ;) Private Sub OpenRptSingle_Click() On Error GoTo Err_OpenRptSingle_Click DoCmd.OpenReport...

This seems to be getting me in the right direction... I have the below code as an event procedure in the "On Click" properties part of my button. But I get an error says "missing syntax error (missing operator) in query expression 'Facility = XXXX' Private Sub OpenRptSingle_Click() On Error...