Search results
-
J
Print Report
Hello, I have created a main report for my db which includes a sub report. On a form, I have a cmdbutton which converts the report into a pdf file and attaches it to the email. Depending from the value selected in a combobox, the report may or not include the sub report. If selection in... -
J
If/Else problem
the control's name is correct. Finally got it to work. What I did, is completely remove the code and wrote it again, once sentence at the time so that I could troubleshoot it. The first part is what probably was causing the problem. Thank you If Me.DEBTTYPE = "partial" And IsNull(Me.RemNo) Then... -
J
If/Else problem
Sorry about the if is null. It was a typo. I removed the quotes. The code does execute until the msg box but but then it gets stuck, meaning that nothing else can be done and have to close the entire db. -
J
If/Else problem
Hello, I am having problems with the execution of a if/then statement and an exit sub procedure. Just cannot figure where is the mistake. I appreciate your help. My project is to create a db to manage refunds which clients are due to my company. Once in the main form, users will select the... -
J
db design
Thank you both for hour help and suggestions. i was thinking of starting with a fix but different rate for each room as they are all different and offer different services. Obviously rates will change each month. After I have entered the basic rates for a given month (this will have to done... -
J
db design
Hello, I was thinking to design a simple db to manage the daily prices of a small apartment which I rent. Because this apartment has three room (Room A, Rooom B and Room C) I would like to ask your opinion on what is the best wasy to design this db.ù My idea was to create some sort of calendar... -
J
Refresh Form
Still nothing. This is exactly what I am trying to do, update a text box following data change in another textbox. Thanks -
J
Refresh Form
Hello, I have a form with several controls like textboxes and combos. I would like to refresh the form when data is changed or updated in any control. I have placed the Me.requery on the after update event of the form but it seems it is not working. Is there any other solution, you can... -
J
Checking if controls are emply
Hello Pat. I have changed the code as you recommended and up to know no issues. The only other think I would like to ask is what exactaly do you mean with BOTH null and ZLS. Thank you and sorry but I am not an expert. -
J
Run Time error 13 Type mismatch
hello, I have modified the code replacing the add with the .Range.Text = MeXXXX. I noticed that the result is the same although not sure what is the main difference between the two lines of code. Thanks -
J
Run Time error 13 Type mismatch
Hello. I am sorry but have never used the .InsertAfter or .InsertparagraphAfter methods. -
J
Run Time error 13 Type mismatch
Hello, back for some help. Almost finished by project but coming up with a type mismatch error 13 which I just cannot solve. The code behind my cmdbutton exports date from my form to a MS Word Template. Data is stored in textboxes and combo boxes. When I run the code I get the error message at... -
J
Checking if controls are emply
Thank you for your help. At the end I have used each of your suggestions and have come up with the code that I am sharing. My idea is to associated the code to a button that exports data to a MS Word template. The controls that will contain data cannot be null therefore the code checks if the... -
J
Checking if controls are emply
Thank you both for the help. While testing Arnelgp's code I have noticed that when trying to enter data in the empty controls, I get an error message (see file) each time I click in a textbox or cbo. (see attached screenshot). Since I really like the idea of coloring the empty controls I was... -
J
Checking if controls are emply
Hello, I would appreciate your help with VBA code that checks if any of the multiple controls on my form are empty. Controls are combo and textboxes. My form has about 5 combos and 20 textboxes. If any of these controls have no data, then I would like to add a msg box saying, please complete... -
J
Unbound TextBox value
No. Honestly I wouldn’t know how to write the code. Thanks -
J
Unbound TextBox value
Hello, I have a form on which I have added an unbound textbox (txtResult) which I would like to return a given value depending if data is entered or not in another textbox (txt3). Currently, txtResult shows a value between txt1 and txt2 (which is located in a subform. txtResult has the...