Search results

Hello all, I have this code that deletes a record from one of my forms, so I tried copying the code into another button to delete records on another form, but it's not working. The new button name is DeleteMgr I am not really sure how the code works. I tried using the wizard to create a...

I hope someone can really help me with resolving this problem. Initially, I was having a runtime error 2302, "can't save file to the output selected", with the following code: Private Sub Export_Click() If IsNull(Me.CustNo2) Then MsgBox "You must have a valid Ship to Customer Number above"...

Hello all, I have the following code that exports my access query into an excel spreadsheet, but it does not open the excel file, it only saves it in my folder, how do I make the excel file open from that folder? Thanks for your help! DoCmd.TransferSpreadsheet acExport...

Hello all, I am getting this error when I use another machine, but it works fine on another machine, how do I ensure this code works on all machines: Private Sub Command53_Click() DoCmd.OutputTo acQuery, "QueryDetails", "MicrosoftExcel(*.xls)", "c:\ Query Details.xls", True, "" End Sub the...

Hello all, How do I write a QBF query such that when a check box on the form is clicked, the name of query runs based on the name of that checkbox. I have a form called, QBF_Form, which has a series of checkboxes. Each checkbox has a name. I have a table, "Type", and I would like to run a...

Hello all, I have a table in access and one of the fields (date) has a default value of =now(). I have an excel spreadsheet that has all the fields in the access table inlcuding the date column (but the column is not populated). When I import the spreadsheet into access, I get some...

Hello all, I need your urgent help with this: I found the following code on the microsoft website (Q304302) to help with creating a dynamic qbf. Private Sub cmdSearch_Click() On Error Resume Next Dim ctl As Control Dim sSQL As String Dim sWhereClause As String...

Hello all: I have a form that is attached to a query. In my query, I have the following criteria: [Company] Like [Forms]![QBF_Form]![Sales] & "*" Or [Forms]![QBF_Form]![Sales] Is Null But it only allows me to search that particular field either when I put in a blank or when I put in...

Hello all: Posted earlier in General, this form might be more appropriate. Every week I download new information into a table. The download has all the information, but the table will spill out any information from the download that is already existing in the table. The downloaded data does...

Hello all: Every week I download new information into a table. The download has all the information, but the table will spill out any information from the download that is already existing in the table. How do I print a query or report right after the download, that will provide a list of the...

Hello all, Please help with this: On opening my database, I have a switchboard that opens up. How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a...

Hi all, I was playing with passwords for one of my access db. I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure...

Hello all, Is there a way to make sure only one user have access to change a database, whereas others just have access to view the forms, queries, reports e.t.c.? Thanks!

Hello all, I have a form that feeds a query with information, in my query I have this: [Company] Like [Forms]![QBF_Form]![Sales] & "*" Or [Forms]![QBF_Form]![Sales] Is Null When I fill in a value in the field e.g. "data*"the query brings up all information with the word "data" in it...

Hello all, I posted this earlier but got no response, please help! I have the following event procedure in my Reset button on my form: Private Sub cmdClearAll_Click() ' Clear All TextBoxes and Set all Check boxes to false (no tick) Dim ctl As Control For Each ctl In Me.Controls If...

Hello all: Thanks for all your numerous help. I posted this earlier, but got no response, your urgent help is required. I usually get 2 error messages on my form. When I set up the table, I made the date field mandatory. The first error message, error 3314, "The field 'Memo.Date' cannot...

Hello all: I have the following code to retrieve doucments: strPath = "G:\Corp\Customer Files\" Application.FollowHyperlink strPath & "\" & textbox1 & "-" & textbox2 & ".doc" This works fine from my computer because the shared drive on my computer is saved on the G drive. I tried using the...

Hello all, Thanks to all the folks that have helped with my posts in the past. I have 2 questions. I have a form with textboxes. When I tab from one textbox to the other, the tab goes to one of the buttons on the page. How do I tab from one textbox to another. Also, I have a textbox for...

Hello all, Do you have a code that would open a saved file based on the contents of 2 textboxes on my form. The saved files would be in: C:\Documents and Settings\100310257\Desktop I have a button on the form, but need a code that would pull up the savedfile using the name in textbox1 and the...

Hello all, I am experiencing this error: "This expression is typed incorrectly or it is too complex to be evaluated….For example a numeric expression my contain too many complicated elements." I think the error is as a result of this expression in my query, I have 9 fields with the...