Search results

Hi I have a stock items in the database that I want to duplicate over and over (all but a few fields are the same e.g. same thing but different size and price) I want to a command buttong to open a new record in the "add new" form (frmTicketing) and enter the stock item with the same...

Hi I have a similar requirement - I have a stock item that I want to duplicate (all but a few fields) because i want to enter a new item of stock which shares a few similar attributes without entering everything again. I have tried the above code but it says I am trying to enter a record with...

Hey I have a form with two calculated fields (based on other fields in the form). When changing these other fields the calculated fields do not update - only when i save, exit and reopen the form to they change. What code do i need and should it be after update on or on change?? Is there a way...

Works like a charm - thanks Bob!

text. does that make a difference? the stock numbers are made up of alpha and numeric characters and symbols

Hey guys had a search around but cant find the answer just yet: Got a search form that when the record is double clicked it opens a form (via a query) with that record - ready to be edited. On the opening of the edit form i get a data type mismatch in criteria expression message box (however...

YE... ENGLAND (same weather). I actually posted and instantly realized the answer so edited the post, unfortunately you were to quick for me and answered before it disappeared!

Hi namliam Of course MS Access help can help with certain things but i dont think there is a proper list, like a glossary of these kind of things. Searching the forum can help but it difficult for people to search for something if they dont know what they are searching for. For example if...

Hi All Is there a full list anywhere of all the DoCmd. or statments or conditions that access uses anywhere? For example, a list of Else statements to be used with IF. Or a list of DoCmd. or a list of what IF can be used to look for/find. I think it may be useful in answering many questions...

What about BACKSPACE? I understand that this is not simply VbBackspace as this enters the character "8". How do I delete the last character in a textbox?

Hi All Ive read so many appointment and calendar threads on here and still cannot find what im looking for. I used to work for a company who had a system that used/was based on MS Access. They had created a proper appointment diary where bookings and appointments could be "clicked n dragged"...

Great, thanks guys

Hi all Can someone point me in the right direction for code to go on the onclick event of a command button to insert some text (e.g. "yourtextgoeshere") into a text box (e.g. txtbox) on a form (e.g. frmtest). And btw, I want to be able to add to the text that is already in the text box, not...

Simple. Thank you so much for all your help

oops, Perfect! But how can I make it default to CategoryID = 1 when i open the form?

Yes, CategoryID is the column In question. If i try to enter that into my queries SQL it says its an invalid SQL statement?? Am i putting it in the right place?

Hi Again I dont follow. My listbox (List18) is based on rowsource "qryProductsList" (obviously a query). In that queries SQL view this is what i ahve: SELECT tblProducts.ProductID, tblProducts.ProductTitle, tblProducts.CategoryID, Format([UnitPrice],"Currency") AS Expr1 FROM tblProducts;

GENIUS! Thanks

im trying the call function but it doesnt seems to be working. When i click the btns it asks me to enter a parameter value for all the fields, 1-5. Trying: Private Sub CommandButton1_Click() fLimitList 1 End Sub with: Function fLimitList(intVal as Integer) Me.List18.Rowsource = "SELECT...

Thanks for all your replies, Im having trouble formatting the query with ANewFieldName:Format([YourFieldNameHere, "Currency") It keeps saying invalid syntax or invalid dot or !. Where should I be putting this code? The format box of that field properties? The criteria box of that field...