Recent content by Puso

thanx for the help i understand your reply ive also found another way to do this by creating a textbox with an iif statement that if a guide is booked for that day assigns a -1 to the tour guide and i use this as my filter to remove it from the query

i need help filtering the data in a combox i have a combo box that chooses tour guides for bookings. what i want to do is that if a tour guide is selected then the tour guide's name must be taken off the list in the combobox on the form but not off the original table. the user should not be...

The query is still not updating, Now it gives me an error: Records were not updated due to lock violations

In my update query it has a criteria clause which says: [Stock Numbers]![Product Code] = [Forms]![Goods Receive Details Mainform]![Embedded40].[Form]![txtCode]

the table is based on jewllery stock, all stock has unique identifyers via the product code. how do you mean i must add a where clause in the dlookup?

please help, i have a form where i enter goods recieved vouchers,in this form if the cost price on the form is higher than the price in the Stock table then the price must be updated, if the price is lower then the price in the stock table doesnt need to be updated. I have a method which i have...

I dont understand what < is in the code if you could please clearify that it would help a great deal. Also please advice on wether this would work on access2.0 as that is the version i am using

Ive tried this and it doesnt work, it brings up an expressions error I dont think access2.0 supports this feature. if yu have any other suggestions please post them

Does anyone know how to trigger a report to print as many times as a value in a textbox. I would need to use this in a ticketing system. eg. a group buys 8 tickets, i create one line item and change the quantity field to 8, i then need to click on a button to print 8 tickets. please bear in...

Thanks RuralGuy, I will let you Know if it works out.

does anyone know how to get a serial cash drawer with kick back interface to open through Access? any help or a point in the right direction will be hugely appreciated

Thanx Murli, I just tried it and it works like a charm.

I have a query running where when i click on a button and it has to find the username, password and which menus the user has access to. My problem is that when i run it only checks the first record in the query and stops there. how do i get it to search through the query record by record until...

maybe an alien