Search results for query: *

Hi Everyone, I'm trying to email through access but I'm not sure how to make an attachment. The code to generate an email works fine but i have been requested to have the ability to add an attachment. This is my code: Private Sub Command23_Click() On Error Resume Next Dim strToWhom As...

Hey everyone, I have 2 questions about emailing if someone can help me. 1. I have a continuous form with a dropdown box in the header. If the user clicks on, for example "foreman", it brings up all the information of all the foreman, name, address, phone number and email address. The code...

Hey Everyone, I have a continuous form with a combobox called 'Groups' in the header. It has a number of text boxes on the detail section of the form. From the combobox the user can choose from 'Foreman', 'Worker', Ex-Worker' and 'Client. Depending on what is chosen in the combobox, the...

Hi All, I have several database's which i have created and were all working fine a few months back. I went to open the database's today and i got the following error The expression On Timer you entered as the event property setting produced the following error: Object or class does not...

Hey Everyone, I just want to follow up on a previous thread i had which 'Remou' gave me code to check if an instance of internet explore was open. thread702-1566978 I have a timer form which counts down from 60 minutes. When its hits 0 i would like to check if any instance of IE is open and...

I have a login form, when the user enters a username/password it opens the main database form and a small timer form, the timer form has 1 textbox which counts down from a certain time. I would like to do the following: 1. The login form is linked to tblLogin. The table has the fields username...

Hey everyone, While my database is open, is there a way of disabling the ctrl+alt+del and windows keys to prevent users from closing the database? Thanks, Nim

I was wondering if the following is possible: 1. I have a form with 2 buttons, when the user clicks on the 1st button i would like an instance of internet explore to pop up, i know you can create your own instance of internet explore in a form but is it possible to get the actual explorer to...

Hey everyone, Is it possible to generate 20 random usernames and passwords when the administrator clicks on a button. For example i have a custom password form which the administrator uses to login but all other users must use random usernames and passwords which need to be generated at the...

Hi everyone, I was hoping someone could help me with the following. I have a form with a combo box, the user chooses from the combo box and clicks the search button and it populates a number of text fields with the information regarding the item in the combo box. I also have a delete button...

Hi Everyone, I have a form with 2 textboxes, a search button and a listbox. The user inputs information into the textbox and clicks the Search button which in turn populates the listbox with the results. All of this works fine but i was hoping someone could help me with the following. I have...

Hi Everyone, I have a combobox with 2 options "DISPOSED" and "IN USE", depending on the option chosen a listbox is populate with "Asset ID's". I have a button to delete the items in the listbox but i cant seem to get it working. The code is as follows. Dim strSQL As String, List As ListBox...

Hi everyone, I have quite a simple problem but i cant get my head around it. I have a number of textboxes on a form which the user inputs information. If the user inputs information and click the logout button i want the form to clear the information and close, if the user doesnt input...

Hi everyone, I have a combobox on a form with a number of "Asset ID's" the user can choose from. There is also a command button when the user choose's a record from the combobox and clicks the command button it opens a report with the information regarding that record. The query for the...

Hi everyone, I have a tab field on my form which contains several textfields, now when i move the mouse over the tab field the form flashes or it looks like its refreshing over and over again. I dont have any "onmouseover" events on the tab field so im not sure why its doing this. Does anyone...

Hi Everyone, Im getting the following error but not sure where im going wrong "the field is too small to accept the amount of data you attempted to add. try inserting or pasting less data" Ive checked the column size and it is not smaller than the data currently in the field so i find it...

Hi everyone, I want to send an email using sendobject but i want to add a Where criteria to it. for example i have: stDocName = "Invoice" Job = Me!Job_Number DateR = Me!Date_Requested strToWhom = InputBox("Enter recipient's e-mail address.", _ "Enter Email Address")...

Hi everyone, I have the following code in the control source of a textbox on the mainform =[Forms]![frmWorkshop]![frmSubMaterials].[Form]![Total] This gives me the total cost of the field "Total" in the subform. What i need to do is place the code somewhere else besides the control source of...

Hi everyone, Can someone help me with the following. I have a main form called frmWorkshop. The main form contain 2 subforms called subMaterials and subLabour. All 3 forms have a textbox called Job_number. What i would like to do is the following, when a user inputs information into the field...

Hi everyone, I have a switchboard with 8 different forms. Im having trouble with one of the forms. When i try to open the form it takes a long time to open, this also goes for saving what the user inputs on the form. This doesnt happen with all the other forms. Ive tryed decompile and compact...