Thank you for taking the time to report an issue.
What's wrong... Please write below.
So say the object is a label and is named lblCategory. Is there a VB command that will change the label's text color? Then Its just a matter of me putting that command into the proper event in the corresponding combo boxes, which I can handle.
I am already unsure how to handle some things though. particulary with the prices and value of my items
I have products in stock which I will need to enter as an initial inventory. Now some of these may have been purchased at different prices but I'm prepared to enter them at a single price per product for simplicity sake.
The confusion I have is how do I handle in the design the changing prices of products. for example chicken, is something I buy a large amount of about 3 times per week and the price changes most days , so the value of the chicken I have in stock needs to reflect this somehow.
In my code I add this parameter:
I thought that String = Nothing gives them a default value.
As a quick fix so I can import the data I made sure if any parameter was null I would pass it a single space character but is that the best way to handle that scenario?
I have table called "ElementsLibrary" and in this table is where I put all the parts of an actual exam. So on a form I would like to be to select the elements from the library that are going to used for the research study (each trial uses some of the same "elements" but there is always new elements being added to the library which are individual to the specific research trial).
I have searched for 2 days to try and find a solution but have had no luck, I did read several post on other sites where people were told not to have a command button create a new table. So I am lost.
I am open to any suggestions on the best way to tackle this situation
All I want is a list of the commands under the Run Command option that explains what each command does. I can't find stuff in my manuals or through the office assistant. Does this exist anywhere
I want to add a new record through a form and when the user has completed the fields they can click on the Add command button. When this happens I would like to add data to two fields not included on the form.
I want to add the current date and also a status of "Ready" to another field. This would happen without user interaction but when the record is being added.
I have tried an update tablename and set field value but could not get the syntax correctly or something because I kept getting an error.
For this example let's say the table is TableName and the date field is AddDate and the status field is Status.
I also want to add code to the command button that saves the record and then closes. I have that code that works but should I update the two fields before saving therecord or use the save record command first and then update the two fields ?
What do you want to do?
* Add a command button to a form by using a wizard
* Create a command button by dragging a macro to a form
* Create a command button without using a wizard
* Customize a command button
I am working with sending emails to customers on their loan account balances.
Have sorted out an email to cover a Loan which by definition is One Record.
Now I want to email a Customer Balance which may have more then one Loan Record.
How do you handle this scenario in vba as you can't just load the code with heaps of variables just in case they are needed.
Is this where you use an Array
I am testing Arrays with some success and a little failure but of course, how do you handle the data in the email message as again, it can have a variable number of lines/records.
Using ReDim Arrayname(intLower To intUpper) to set the Array size to suit the record number - Is this how you would do it?
I could use a table to hold the data but then we still have the issue of the email text / body