Search results
-
A
Open a form in a specific record but in different state
MSAccessRookie, thank you. When I do what you suggested and I click on the "Assign Photos" button, the form doesn't open. Instead Access asks for the parameter ProductID. Maybe I didn't write it correctly. I want the form to have the ProductID pre-entered, even though the form "Photos" and... -
A
set cursor to last character as opposed to selecting contents of the field
OK, found it. Me!FIELDNAMEHERE.SelStart = Me!FIELDNAMEHERE.SelLength -
A
set cursor to last character as opposed to selecting contents of the field
How can I do exactly the same thing when in Access 2003? -
A
Open a form in a specific record but in different state
Thank you Bob and DCrake. That worked great. The problem I'm facing now is that when I click the "Assign Photos" button (DoCmd.OpenForm "Photos", acNormal, , , acFormEdit), the form "Photos" doesn't open with the ProductID preselected so that the user may just assign the photos. Instead, it... -
A
Open a form in a specific record but in different state
But where do I type the text DCrake wrote? Is it at the button's OnClick property? -
A
Open a form in a specific record but in different state
Aha! So that's what "Fred" meant... Thank you! -
A
Open a form in a specific record but in different state
Thank you all for your answers, but I'm afraid my knowledge level isn't anywhere that high... Could you please be a bit more specific? And please use the names of the forms, buttons and tables I used before so as to help me understand what I click on what. Thank you all again. -
A
Open a form in a specific record but in different state
Hi to all! I have a form "Products". I want to add two buttons, one named "See photos" and one named "Assign photos". Both of them will open the same form "Photos", but the first will open the form in a state that will not allow the user to change anything, while the second will allow the user... -
A
Adding multiple photos to an item
Thanks Simon, I tried that last night and it works like a charm. I'll stick to Access 2003 for now! Thanks again -
A
Adding multiple photos to an item
Thank you. Are there major differences between Access2003 and Access2007 versions? I mean, do I need to learn everything from scratch? -
A
Adding multiple photos to an item
Dennisk, can you please explain more in detail what you mean? I'm certainly not going to store photos in the database (bloat-alert, as you noted), but I don't quite understand what you mean. Thank you. -
A
Adding multiple photos to an item
Thank you Mike once again! Any angels in here pleeease? -
A
Adding multiple photos to an item
Well, I'm afraid I didn't manage to sort it out... Northwind does have a sample of what I'm looking for in the Employees form, but I can't understand how to create a button in a form to add a photo. It looks like I have to add some code behind the "ADD PHOTO" button that I'm unaware of. Also... -
A
Adding multiple photos to an item
Oh, I got it now, sorry... Thanks again Mike! -
A
Adding multiple photos to an item
Thank you Mike. The problem is how do I add more than one picture per item, so that this 2nd or 3rd picture is viewable both in the form an the possible reports that will be created. -
A
Adding multiple photos to an item
Hello to all! I am building a new database and I'd like a bit of help The database stores various items for which there will be 1 or 2 or 3 photos of each, along with other fields such as description, date of acquisition etc. How exactly do I create the table so that I can store 3 pictures on... -
A
Invoices table(s) with one invoice refer. to multiple products
Dear neileg, thank you for your quick answer. I didn't know the exact terminology for inventory or stock control... I'll revert if I get stuck... Alexander -
A
Invoices table(s) with one invoice refer. to multiple products
Hello to everybody, I want to create a database that (among other things) will be storing invoices coming from suppliers. These invoices have a single number, multiple products with their respective prices and tax (each product can have different tax, 9% or 19%, but that can change in the... -
A
no Report avaiable message box
OK, Bob, thanks a lot. You are really very kind and helpful!