Search results

Sorry for the delay in aswering. Yest, rates can change every month and I will type them in manually

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...

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...

that worked. Thanks

Still nothing. This is exactly what I am trying to do, update a text box following data change in another textbox. Thanks

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...

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.

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

Hello. I am sorry but have never used the .InsertAfter or .InsertparagraphAfter methods.

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...

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...

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...

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...

Thanks you. I will on the code.

No. Honestly I wouldn’t know how to write the code. Thanks

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...

Thank you Minty. Removed the error line, made the changes and... the code works great now. Appreciate everyone's help.

sure, no errors. It was working up until a few days ago although erroneously because in both cases (whichever value I entered in txt1), it exported data to Word.

Exactly. When I enter "Partial" in box 1, I get the msgbox and the code stops running. If, on the other hand, I enter "Total" the code does not execute, meaning data is not exported to my Word template. Thank you

Hello. Sorry for not having simplified my post. I will try to explain it better. I have a form which exports data to Word using bookmarks. Code should execute depending on the value I enter in textbox (txt1). If the value in txt1 is "Partial", then I only want a msg box and after that the code...