Search results

Thanks Pat & Ken It will take me a while to digest your suggestions,I will get back to you with my results (or further questions) Regards Bjackson

Rich, i dont want a spreadsheet,because thats sort of where i am at the moment,so heres the 97 version, and thanks in advance for any suggestions. Pat,I know this is really simple database stuff, but i am struggling to understand in which table the actual price rates would go.Each supplier...

Now i know what KenHigg meant "You game or had you rather just get some tips and wing it" Well it would seem you 2 guys agree to disagree and look like you may have a history of that , but that hasnt really helped what i am trying to do.I really would appreciate some help. I'll try to explain...

Crikey,i just wanted to get some help, not start WWIII. perhaps i should withdraw the thread :eek:

Well i was hoping to get some tips on what extra tables would be needed other than the 4 i have named.I guess i would need a table for sheet sizes and some sort of pricing table but i am not sure on how to relate these tables to the laminate selected,and of course an order table.I am not well...

i am trying to set up a db for purchasing laminates but cant get my head around the right way to structure the tables. Each order would consist of 1. selecting a supplier 2.selecting a brand of laminate from that supplier 3.selecting a colour from that brand 4.selecting a finish for that colour...

Spelling includes any spaces.Your form name length=13, but in your code the length of the form name=12, may be you missed a space Regards Bjackson

the error message is correct,you have not spelt the forms name correct try this highlight the forms name in the database window press the f2 key right click and copy the forms name now paste that name in to your after update event DoCmd.OpenForm "frm-RPT (SMT)", , , "[ref no] = " & Me.Ref_No...

have you tried Me.txtResult = dateadd("d",-me.txtdate1,nowdate) & " day(s)"

Thank you Wayne, that works i had used Me.DateTimeField = Me.ShortDate & Me.LongTime, i didnt realise it needed the space in between the 2 values

I have a form where the user has to select a date then select a time for a specific task to be done.I want to store this value in 1 date/time field in a table, but am having trouble joining the two values together to form a valid date. The date TxtBox on the form has its format set as long...

If you must use dlookups and the like have a look at the domain functions replacements that i posted in the code repository.There is a subsitute for all the domain functions and from what i can gather they replace the functions with queries.You will find a huge performance hit if you replace...

Try using the no data event for the report, so that the loop will continue to the next report that has data.

i think you need to move your order by SELECT tbl_Country.Cou_ID, tbl_Country.Cou_Name FROM tbl_Country UNION SELECT "*", "<All>" FROM tbl_Country ORDER BY tbl_Country.Cou_Name

Thanks Mile-O-Phile its early morning this side of the world so i havent had the opportunity to try your suggestions,but to answer your questions 1.i use 2 fields because i am easily confused when working with date/time fields.I know i should only use one.maybe its time i...

I am trying to update 4 fields in a table using a update query but cant seem to get it right.I keep getting an error message "missing operator in the expression 8:17:PM" or if i leave the TimeStr out of the update the date saved in DateStr is 30/12/1899 Dim TimeStr Dim DateStr As Date...

Thank you for your reply Unfortunately this wont work in Outlook Express,it keeps wanting to use OutLook to send the mail Ill keep trying Regards Bjackson

Is there any way to automate adding an attatchment to emails in access,similiar to to sendobject action.The attatcment is a .Txt file and i need to use Outlook Express not "OutLook". Can anybody help Regards Bjackson

You could also use if not isnumeric(me.NumberInput) then

I dont know if the problem i struck with msword logos is related to your problem but you never know. I had to tweak norton anti virus as it was causing a problem when i wanted to open or design any reports that had a OLE object in it