Search results

Thanks Rich I now understand what you were talking about!! I didnt know about the properties on the detail bar. It is working fine now!! Thanks!! DaniBoy

There is no on_format or print events I looked for the on_format or print event on the reports events and could not find does events. Let me explain what is wrong again and try to be more clear on my explanation. I have a form called "frmCorrectionForms" that has a check box called "chkVOID"...

Hello, I have a form that has a checkbox called Void. When I check the chkbox I have it to display a picture that says "VOID" it all works great on the form. Now, I have a report that gets its source from the form. Everything works goos but the checkbox. I put the same pictures on the...

Thanks a lot ghudson!! I think thats waht will work, thanks for your help. I will let you know what happens. One more thing, do I look in access help or windows help? Daniel

Thanks ghudson ghudson, What I want to do is not just to open Access, I actualy need it to run a batch file. I was reading this thread and thats exactly what I want to do. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36445 I want to be able to copy a file on my...

Hello, I made a simple batch file on Windows XP, I saved it as autoexec.bat on the Command Prompt. When I start my computer it does nor execute the autoexec.bat file. Is there something that I have to do for it to work in XP? All I tried was to open Access when I start my computer. I am also...

This is great!!! Hello, I have been updating all my computer, well all 4 of my office computers individualy!!! jejeje, I was getting sick of people asking for simple changes one at a time!!! I kept telling them to give me all the changes at one time, they dont seem to understand that!!jeje...

Yes you did I tried that but am not that good in code!! I could never even got the start on that. Do you have an example DB with that scenerio? DaniBoy

Hello Agian Well here is the DB!! Finaly!!! The AS400 where I get the tables was down!! Then I made it small , it was 73 megas I made it 760 kb. I hope you see what i mean by the error. Goto queries and look at the Correction Forms 1&2&3 Decrease or Increase in desing view, try to add this to...

Hello, I want to be able to count all the workorders that have the "NewCheckBox" to true. I also made an expression called days that gives me the datedif between DateRec and DateCompleted. I want that to be greater than 7 Thanks here is the code that I have and it gives me a "-1" answer...

Thanks Ok, I will upload the DB, I will have to get the data size small for zipping it. Thanks DaniBoy

Tried that and still Bad!! Thanks I did see that and added the rest of the brackets, I still get the same error, one thing, after I click on the OK button on the error msg, I get a blocked flashing curser on an equal "=" sing on the first if statement of the 4th quarter code. I put "This...

Hello, I created aql query on the design view and then switch it to sql view, I studied the code and figure out what was going on. This is what I had: SELECT WorkOrders.WorkorderID, Addresses.[Parcel#], WorkOrders.NewCheckBox, WorkOrders.DateDelivered, WorkOrders.FiscalYear, Trim([XST_FNAM1]) &...

Where do I insert this code at? Thanks DaniBoy

Hello, I have a form made from a query that has all the fields on the query. I have a drop box to pick the record I want to see. Lets say that I pick the OwnerID#1, and this OwnerID#1 has an address built from this fields: txtStAddress1 txtStAddress2 txtCity txtState now, I want to be able...

Hello, I am kind of confused with the naming convention on fields. When I'am creating a table do I need to put txtName for the field or just Name? Is it a good idea or I only need to do that on my forms and reports with unbound fields!!? DaniBoy

Thnak you Thanks a lot for the help, I will go try this code DaniBoy

Ok, one more thing!! I have it so that the code only checks for the username and password, what if I have another criteria that I want it to check? I decided to put this password form at the start of the application and I added a field on the security table called "Position" that has a combo...

I figure it out!! Thanks DaniBoy

Thanks Thanks, works fine but still not doing what I need it to do, Ok, am actualy already clicking on a botton on my first switchboard. This opens my security form, from there I want it to open another switchboard that is the Administrators Switchboard. Thanks DaniBoy