Search results

Hello, I have a form with a cmd button which refers to a macro to quick print the active form. Suddenly, the print function does not recognize the default printer (PRT1) and all prints are sent to a different printer (PTR2) which is not the default. Both printers are shared as part of a...

Hello, I am creating a small db to manage member of a sports club. I have a two main tables: Members and YearlyFees Memebers is to store general info. Yearlyfees is to add the yearly fee each member pays. The unique code for both tables is ID. I first add a new memeber, than save the record to...

I have created a form on which I have two textboxes with a Date format (mm/dd/yyyy) Text1 will be used to store a specific date Text2 should automatically add 1 month to the previous date I have used the following code to the Default Value property of Text2 but after entering the date in...

Hello, I have a form with a combo and a textbox. The combo has its records source to a table named documents. The text box is unbound. I was wondering if if would be possible to copy different records (not at the same time) from the combo box and place them in new lines in the text box...

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

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

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

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

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

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

Hello, I am having a problem with an IF/ELSE statement, although used many other times. I have a cmd button on a form which executes or ends a certain code, depending on the value in txtbox1. Thank you for your help If Me.txt1 = "partial" Then MsgBox "Sorry, you cannot perform this action is...

Hello, I have a form which exports data to a Word file and saves it with the value indicated in the textbox (FILENO). I then have a code that opens Outlook but I am having problem in attaching the correct file. The code (wrong) that I have come up with, will only attached a file with a...

Hello, I have f form used to export data to a MS Word template which is then attached to a new Outlookl session. Since the recipient email address can change, I would like to choose the email address directly from a combo available on my form , which lists all the recipients. The part of the...

Hello, back for some help. I am having problem when exporting data to Word. On my form ( records source is Table1), I have a textbox (Amounte), with format Euro and decimals as Auto. When I type or open the form, the value in textbox Amounte is displayed correctly (ex. €100.50). When I export...

Hello, I am exporting data from a form to a Word template using bookmarks and would like to include an input box which users can use to add additional information which is not stored in the form. I am getting an If without Else error and not sure if the code is correct. Appreciate your help...

Hello friends, still asking for your precious help. I have a form with a record source based on a query. It has a textbox which can indicate two different values: A or B. If it has A, I would like disable other textboxes. If B, then the textboxes should not be disabled. I have tried several...

Hello, I use the following VBA to copy a record from a textbox (FILENO) to the body of an email (EMAILTOCLIENT). Me.EMAILTOCLIENT = "Hello ," & vbCrLf & vbCrLf & "this is your file number: " & " - " & [FILENO] & " " I would like to give the file number a SSN format (000-00-0000). I have...

Hello, I am using the code below (it's only a part of the whole code) to open Outlook from a form. Is there a way I can also add the Signature already available in Outlook, in the body of the mail? Thank you for your help. " ' Create the Outlook session. Set objOutlook =...

Hello, I have found a code that opens Outlook, adds the email address in the To line and a text in the subject line. I would like to place this code behind a button on a form. I was wandering if there is a way to include the value of certain controls on the form (ex. txtFname, txtLName) in the...