Recent content by mystery45

Not sure how complicated this is. I am creating a simple form that opens an existing word docuement (which i have working). once the person is done editing that docuement they need to save it off to another folder. what i would like to do is link where they save it off to a hyperlink in an...

Hi all you guys have been a great help in the past. The DB admin at work is swamped right now however here it goes. I have a form that all it does is allow the user to search the database for a processing date and generates a report for that processing day. It is setup so that there are 2...

thanks for all your help. I made the query and added the [CDC Date] with an integer parameter which is what it is to the criteria field. If Me.CDC_Date = 0 Then Exit Sub If Me.Dirty Then Me.Dirty = False DoCmd.OpenReport "Game_Report", acViewPreview, , "CDC_Date = " & Me.CDC_Date this...

Update ok i just got it so that I could get 1 report. now i need to get it so that i can get multiple records into 1 report. also does docmd.openreport only work on strings or can you use numbers?

I am trying to build a report from my database. The people that will be wanting this report will be wanting to view specific days of processing. Everything is keyed to the primary key which is called the CDC date. I am not sure how to get access to allow someone to enter multiple CDC dates...

go under the date field and in properties there is a item called font weight. that is where bold is just turn that on and you should be fine.

You guys were really helpful the last time I had a question and I have another quick one. I have a text box that needs to be divided into Multiple colums and rows. is there anyway to do that. It is for data entry or would a list or combo box be better? I need at least 2 rows and 5 colums...

Again thanks a lot for your help. I will get with the DBA at work and see if he can't help me clean it up a bit. I tried making a reports table to hold all the reports in however when you do that and make multple forms using those reports it activates the check mark for all of forms that use...

Thanks so much for your help I greatly appreciate it. OMG been working on this issue for like 3 days. Really this is going to be used for daily processing of tasks. Someone made a spreadsheet but i figured it would be easier to make a database to keep track of everything. Plus it is neater...

ok here is it try these cdc date (primary key) 7384 Sunday (should be disabled) 7385 Monday (should be disabled) 7386 Tuesday (enabled) If i can just get this one box to work i can replicate the same thing for the others that i need. you can access everything through the Spare Processing...

Ok i rebuilt the whole thing and imported in it. i then selected the on current from the forms properties for some reason it showed up current instead of on current. when that happens it doesn't like the if statement I get an error saying that it can't find the field "spare processing" but...

Sorry i am just trying anything. NO matter what code I put in access seems to just ignore it and go on about its business. I can still check and uncheck the win_load check box. This is very aggravating. I changed it to form_OnCurrent Still doesn't work. Is there something I need in the...

Thanks for your quick response but like everything else I have tried the same thing happens. The box is still enabled and I can still click on it. Check and Uncheck it. I don't understand why it isn't greyed out and disabled. would it be better to try .visable instead of .Enabled? it is like...

yes i have been trying to solve this issue for a while. I can't find the solution. here is the issue. I have a main form. The primary key is a tracking number. When this number is entered it fills in both the day and date fields on the spreadsheet. I have several subforms. Different...