Search results

I am creating a dispatch list for our manufacturing shop. I am Grouping the Report By Work Centers. Some Work Centers could have 1 page of data printing out daily and others could have up to 20 pages daily. Obviously they cannot do 20 Pages Worth of work in one day so it is a waste of paper...

in the query module? I must be missing something in my instalation then.

I found the problem. I guess the replace function will not work in a query but i found a way it can. You make a function in a module and use that. I did the following in a module and it worked great using the replaceq() function I created Function ReplaceQ (pString1 As String, pFind As...

I am trying to use the replace function in one of my queries and i get the error "Undefined function replace in expression". I was under the impression that access 2K had this capability. The replace function works in the form code. Is there some reference file I am missing or something? Any...

I am trying to create a PO Reciept Label that prints out once the data has been posted to my Sql Database. What I wanted to do is grab the data right after it has posted and print it out on a label using my default printer. Is there a print command where you can just print these variables out...

nevermind. I had a requery statement in my click event for some reason. It's all good now. Thanks

Those are good suggestions. I will fix those. The event is running in the before update of the control. The part number is a string becouse our part numbers use alpha numeric charachters. Do you know why it is going to record one once the new form closes?

I have a form that checked to see if a part number was entered into the DB. I Have made some code to check and if the part was not entered open up the part entry form for them to enter it in. The problem I am facing is that once they are done entering the new part in and close the form the...

thank you

I have a datasheet form and was wondering if anyone knew how to make a date automatically enter when a record has been changed.

I have a program that uses continuous label stock. The width of the label stock is always the same but depending on certain variables the hieght of the stock varies from 1.5 inches high to 12 inches high. I need to be able to specify in code what size i want the page to be so I can have my...

I am using this code exactly and Devices and Device are not showing as options to choose from. I get a user type not defined error. Is there some reference i need to include or something? Dim devs As devices Dim dev As device Sean

acctually sp1 for access 2k fixes the page formatting issue.

nevermind. I used dlookup. It worked exactly the way i wanted it to. Thanks Again Sean

Can I send you my database so you can help me out please. I have no idea why this is so hard for me but i am really confused. I tried using the query like you said but i can't get that to work either. thanks sean

Can I send you my database so you can help me out please. I have no idea why this is so hard for me but i am really confused. I tried using the query like you said but i can't get that to work either.

I know I have them messed up. What i am trying to say is that i do not think that i am getting the data from the sql query. after the code passes this juncture set rst = dbs.OpenRecordset(mySQL) rst is showing the sql statemnt as what is in it. How can I find out if I am getting values out...

I have gotten the sql statement to run without errors. The problem I am having now has to do with the way I am Assigning my fields the returned values. ( Error: The value you entered isn't valid for this field.)Could you take a look at it and tell me what I might be doing wrong. Actually the...

I like to use sql statements in my code. It seems more like what i want. Now i just have to get that coding part set. All i do is dim rst as a recordset right? Thank you Both answers were very helpful. I am just so braindead today.

I am having a Braincramp. I have a subform where i want a user to type in a job number. Once the jobnumber is typed in I want to go out to a table in my database and get the POID, Serial number, and partnumber and auto input them in my subform automatically. I think I have done this before...