Recent content by katzi4eva

sorry i didnt explain very well. i use one form to select items using checkboxes to send back to my customer. i click a button on the form to generate a report to accompany the units. also in the code for the button i run a query which updates yes/no fields to mark as shipped within my main...

Hi I have a report when i send units back to the customer, the report generates an ID in a list box (a query picks the last ID used and adds 1) after the report prints i use an update query to mark the units as "shipped" with the dates in the main table. i need the update query to use the...

Thank you for your reply, i'll try that in the morning! The main use of the data will be an export that i send to the customer so when i do the export i would have to add the "RO" to the field again?

Hi this may seem obvious and glaring me in the face but i can't see it. I have a form I use for data entry, it needs to generate an id called RO Number and i need it be generated by access starting at number RO129036 and then keep adding sequentially, so RO129037 etc etc. as i already have...

Hi My database exports data to one of our customers who then inputs the data into their system. One field i have is "RO Number" which i have as an autonumber which works for the purposes of my part of the system. However they have it set as "RO9999", (Their system has been set up for years...

proper daft question, where do i put that? in the query that i use to create the export?

It still does it in the export but not in my table!

OK, next question! my field "receipt date" is date/time, short date which in my table stores 27/11/2014, happy days! when i export this data, it shows "receipt date" as 27/11/2014 00:00 - can i take out the 00:00 for the export? :)

Well think have maybe worked out one way of doing it, for the afternoon query i have used >Now() And <Now()+1 which only selected the record i had entered in the afternoon and the morning one i just used <now() but it means i have to remember to run the queries at the right times!

Hi, Ive found alot of reference to using dates to find records but not time, I need a query to pull up records entered on that day before lunch time and another query will pull the records entered after lunch. receipt date is date/time field receipt time is date/time field to get records...

OMG, i knew it was something stupid, it was a text field, i feel so silly right now! Thank you :)

Hi, Honestly, my database is now doing my head in! It has to be functional before the end of January and just little things are now really bugging me! Have put a post up in Forms about a date function but no one has replied yet, think am impatient! ha ha!! :)

Hi I have a form for the user to enter new units which arrive in our warehouse, one field in DOM (Date of manufacture) which cannot be a date in the future obviously but could be todays' date. there is table level input mask to make the date 00/00/0000. i have this code on the form: Private...

Morning everyone! I did Computing at college a few years ago and thought I was ok at Programming! Now im not so sure! I am creating a database for a new project at work and whilst the majority of it works "well" there are some bits I need your help with! Some are easy but doing my head in as...