Search results

Thanks for that, I've tried do do this, but it doesn't seem to work, do I need any vba?

Hi all, Could anyone help me? Im trying make a form that will help me with my prices, basically i would like a form that has a series of drop down selections and after choosing them i get my price. So for example, i have a table with brands - we'll say car brands, so the brand is one field...

Thanks for that, ok, instead of splitting the table i just created a new one with the item details, so i now have my main database with customer info unque customer id etc, then i created a new table for the customers items. I created a field called customers and made this the foreign key. I...

Im a watch and clock repairer with a store, and I've built a database to keep all customers info. I have a table with most of the info (my main table) customers name address etc, and also the job info, eg the item they have brought in and what is required, cost etc, then I have another table...

I'm trying to make a copy button and a paste button to reproduce some of the details from an existing record to a new record so i dont have to fill in the fields again if it is he same person, i have got it to work great provided there is some text in the field, i get a null error if one f the...

I have a couple of forms which i use as a receipt to give my customers, i have 4 different formats depending on the item the customer has. The problem is, 2 of them will only print the header and i have no idea why! the other two print absolutely fine. Is there a control or setting i need to be...

My Apologies, it was showing all entries with that status regardless of the time frame, ive now changed it so my criteria is in each box and it works fine. My problem was, i realised i had this <Date()-7 instead of <=Date()-7, i was missing the equals sign. now ive changed it all seems good.

yay ive done it! i placed <=Date()-7 only in the first criteria line, works fine. Thanks for your help.

Hi Thanks for that, ive tried it and it gives me a different result but still not working :banghead:

Hi Brian, yes I've tried them all, I have an entry for each status with a date for longer than 90 days ago but the only thing that shows is whatever is first, I'm trying to generate a report for anything older than 90 days and has any of those status. Im baffled.

I don't know what this means... do i have to place this entire thread in my criteria box? @brianwarnock those are not the only status's there is a few more which i don't want to be in the results. i think i have about 9 different status's such as estimate required, estimate given etc Thanks

Hi, I'm trying to make my query return all entries with a value in status field and a value in status date. The problem is my status field, i have about 5 different status's and i want it to return an entry that is any of these status with status date more than 7 days ago. Ive attached an image...

I think i have figured half of the process out. Ive created a new form, which has only the fields i want to print and the correct layout. Ive created a macro button on my main form that when i click will print the record. It works, but at the moment it prints all records from the start. So i...

Can anyone please tell me how i create a macro for my form that when i click will only print certain fields from that particular record? and would i also be able to specify paper size etc? Id really appreciate any help as this is the final hurdle to having my database finished. Thanks in advance

Does anyone know if it's possible and how I could make a button on my form to then print a ticket for my customer? I basically have a database that I use to book in a customers item for repair. I want to then be able to click a button that will then print a ticket for my customer through my POS...

I choose a yes no field, the one which you place a check in the box for yes or leave for no. However, to solve my problem I changed it to short text I have a table with yes or no so used a combo box and used this as the value and it works fine. Thanks.

Ive tried all of these and i get a data type mismatch in criteria expression error

Hi, Im trying to run a query to show results based on if an item has a certain value in one field, it works fine, but then i also want to select if an item has a value i another field, its a yes/no value which is a checkbox, could anyone tell me what i need to insert into the query criteria...

Thank you!! it works fine

ive already tried to do this and nothing happens, could you tell me the code i have to put in? The field name that i have the options in is JobStatus and the field with the date i want to populate is called StatusDate Ive tried a few different codes from posts i have found but most of them are...