Search results

Its showing numbers as the data is numbers! If you need the number value to represent a name you need to relate it properly or use a combo box on the form. I presumed you meant Employee name so i changed the textboxes to combo's and made them lookup the names in the table. Format set to 2...

Just tried it with some old DB's works a treat, i will be using that again in the future! :cool:

bonoman- check and re check the syntax but i think you have a null value somewhere. Try checking the fields to be used for NULL first. if isnull([cboStudent ID]) then msgbox "null student id" else if isnull(cboClass Code) then msgbox " null cboclass" else "your code here" dcx693 - Can you...

Thanks Pat thats fixed it. Need to keep it MM/DD/YY as this is the same as there current "system" (about 400 books), so unless there's a fire i have to stick to some of the old conventions ;) but its not a key field it just for display purposes.

DOH!!!! ignore me i just figured out what ya mean. Works great in the first box but..... i am taking this txtbox called dater2 and combining it with a ticket number thus =[Dater2] & "/" & [ticknum] the date formating goes back to the standard english?

i dont have a American Date format in my format options, do i need to apply in code?

Okay i will change it DMax no worries. Also combining in the date part of the ref number generation it there any way to get the date in American format mm/dd/yy, even though the rest of the DB will not be (DD/MM/YY). Im currently getting around it with 3 DatePart txtboxes then recombing them.

Works a treat Thanks

I need to build a numbering system for new records in a database that combines. month date and ticket raised in day. So today would be 2/9/ and then the ticket raised number 2/9/1 for the first 2/9/2 for the second ect ect. I need to use this method as its replacing a current system and they...

You can add unbound text boxes to your report then set the Control source to lookup a textbox on a form. =[forms]![yourform]![fieldwanted] The fields don't have to be in the record source of the report they just need to be on an open form, which can be where the reports are triggered from or...

I found a solution, it was a adaption of a technique dcx693 used in a previous thread using 2 querys. I just needed to get past looking for a Dsum or code solution. Thanks again. :)

Thanks Guys, Can i build the running sum in the query itself and put a <[amount] filter in to restrict the amount of data the query feeds into the report. I have WEEKID and USE. Just want to do running sum of amount each week. Then stop the query once USE get to a certain value, and count the...

I have a running sum on a report. Can i stop the running sum once it reaches a certain number. Many thanks

Many Thanks :)

Im having a puzzeling problem with a form requery. I was happly using requery to requery a form, but once i installed the DB FE onto another users machine, the code stopped at this line. so i replaced with me.form.requery which worked fine for a while but has began to crash the DB giving...

Thanks Guys

i dont want to filter the data in the colom just control the name thats displayed on the query field names. So in the same way you can use IE whatevernameilike: actualfieldname i want to use a value passed from a form in the whatevernamei like section. IE Whatevernameilike[fieldfromform]...

I have a select Qry that im outputing into an excel file. I can name the field titles to better names ie. 2003 results: [x]*[Y] Which is fine but i want to be able to show year name from another field in my form. ie =[year] & "results": [x]*[y] i know you can do this in text boxes but i can...

Yep it was that pesky " a few extra ) and a Stock instead of a stock2. Runs perfectly now! Thanks very much for your help, Gumbyd and dcx693.

Actually in getting a "type mismatch" which i guess is a syntax error. Using & " WHERE ((([tblStock2].[RawMaterialID])= " & intRawMaterialID & " ) And (([tblStock2].[WeekID]) Between & [forms]![frmMainMenu]![weekID]-4 & " And " & [forms]![frmmainmenu]![weekid]+100)) & " _