Search results for query: *

Hi All, I noticed that the new version of Access has a bluetooth add-in. I wanted to find out more information, but cannot find anything online so far or nothing in the help file. Has anyone read anything about this new add-in? thanks in advance!

Hi All, I have been wrestling with this request for a couple of weeks. I have a single form view form in Access 2003. I have been asked to make it so that the user can duplicate (copy, ditto) a record in the details section of the form (subform). I found Allen Browne's code and some example...

Hi All, I have the following code I am wanting to add a WHERE clause and I have tried adding it almost everywhere, but it does not work. I don't get an error, but don't get what I want. Private Sub cmdViewSources_Click() wherestring = vbNullString If IsNull(txtSourceKeyword) Then...

I have a date and a time column in Excel (2003) and I want to assign a period from 1 to 10 depending on a date range and time cut off. Would I need to concatenate the date and time columns into one column? For example, period one would be 5/2/2006 12:00 thru 5/16/2006 12:00. Cut off date is...

Hi All, I have a main form with four tab controls. In each tab control I have main form/subform(s) combinations. I have a listbox search in one of these tab control main forms for the user to search the records previously entered on that form (they do not want to use the record navigation...

doing? I have been troubleshooting this code because it WAS working last Friday and no longer is. I am not sure why. basically I have a text field on an access form called "txtsourcekeyword" the user can search for a particular MATERIAL_ID (CDW-01;text field)if he/she knows it or enter wildcard...

Hi! I've looked everywhere and I can't find what I need. I know it is simple I just don't know the syntax. I am fairly new with VBA, but getting better. I have a form with a checkbox (not option group). If the checkboxed is checked I want a message to display to the user that they have to fill...

Hi All, I have tried several ways and I just can't get it to work. I have read several suggestions online and in this forum, but have not found anything like my case. I will try to explain. I have a main form with subforms in a tab control. The main form contains building information. This...

I have a main form with a command button. This button opens a small pop-up form where I can add building information for a new building. I enter info on the pop-up form and then close it to return to the main form. I want the newly added building information to be available so that I can...

Hi All! I want to create a formula in Excel. I thought about using the 'AND' and 'OR' logical functions. Can they be used together with an IF statement? This is what I am trying to accomplish. I have text in cell BG. I want to look for "Red" in BG and where it is either "100" or "5000" or...

I have a form with a place for a photograph. It looks the image control is retaining the value that it had from the last record that loaded it. Basically when I go to the next record I see the picture from the previous record. I don't want that. I want to see an empty image control. How do I...

I have a form with a place for a photograph. It looks the image control is retaining the value that it had from the last record that loaded it. Basically when I go to the next record I see the picture from the previous record. I don't want that. I want to see an empty image control. How do I...

Hi All, I am using MS Access 2003. I am using code to link to images in an Access form. I am able to see the images for each record, but if I happen to go a new record and then navigate to the first record I can't see the images anymore, but I see file names in the image control instead of my...

Hi All, I am not sure if this can be done. I have a standard input form that is filled out by the user. I have gotten a request to have another functionality added. The user wants to be able to enter information for the current record, but if he or she needs to look at another previously...

Hi All, I have the following statements. I have tested them separately and they each do what I want them to do. When I try putting them all together to make one statement I get "an aggregate function with too few arguments". What am I missing. IIf([source]="ACGIH" Or "NIOSH" Or "OSHA" And...

Hi All, I have a form where several filter options are presented to the user to filter a report (Access 2003). I have two listboxes that depending on the combination a calculation is run. Right now, I have the calculation being performed in a query, but now we have added other elements to it...

Hello All, I am trying to build an input form in Access 2003. The form as I see it has three parts. One part captures the site name, address, and question and answers for 6 basic questions. I have more questions on the form (7 thru 10), but each has a series of subquestions yes/no for the...

Hello All, Someone generated forms using PHP so they are on a website. The forms are updated via the website and Access tables are populated. Is there a way that I could fire off an e-mail to people when the PHP form has been updated? This is a dispatch scenario. A complaint comes in the form...

Hello All, Someone generated forms using PHP so they are on a website. The forms are updated via the website and Access tables are populated. Is there a way that I could fire off an e-mail to people when the Access tables have been updated? PHV helped me with sending e-mails when a form in...

Hi All, I have searched in the posts and I have found some information, but I do not want to send an attachment or report snap shot. I want an e-mail sent to 5 people when an Access form has been updated with a one-two sentence message and to not reply to the e-mail. Is this difficult to do? I...