Search results for query: *

I'm writing a lot of code to go through a LARGE customer file and replace an existing customer number with a new number (I've pasted a snippet below). What I don't know how to do is have it continue going if that number is not found. I don't want it to drop out of the routine, just go to the...

Help please: I'm using the following code to open a query and based on the value in the field 'Status' display a particular form. THe value in status will change as the process is completed. I need to be able to read the value and if it's 2, I'll open a different file. There's something wrong...

I have a form in Access2000. When a button is pushed for action, I want to check that all fields have been filled in. I'm trying within the event code of the button to write this code: If RptDate.Value = Null Then MsgBox "There must be an entry for Report Date." Exit Sub End If If...

I'm sure this question has been asked, but I couldn't find it. I want to limit my database to only one user at a time. When someone is in making changes, it won't allow another user to enter until they are finished. Can I do this? and how? Thanks in advance, MrsTFB in Tennessee

I have an Access (2000) database that has a query ran from a form. I want the value that the query asks for (Part Number) to be whatever value is in PartNumber field on the form. I don't want the user to have to enter the part number for the query to run. I know it's possible, just don't know...

I have the code below: Workbooks.Open Filename:="F:\charts\HR-EPA WORKBOOK.xls" It is a password protected file, but I want the code to operate without the need for the password. It is going to open, write to it, then close it all within the code. It prompts for password still. I know...

I have an open event in an Excel workbook that after Saving the workbook as a new name, I want to disable the sub. The disable would occur with a click event on a button on the SignIN Form. Is this possible? Here's the code: Private Sub Workbook_Open() Application.ScreenUpdating = False...

I have a row of information that I insert a line into at the top and add information. My formula is : =SUM($C$4:C10)/SUM($B$4:B10) I put the absolutes in because I want the beginning cell for calculation to ALWAYS be cell 4. But, when I insert a row, or cells it still moves to 5. I thought...

I have a workbook that has a simple workbook open event (below). Later, I save the workbook with another name (unique to creator) and would like the workbook_Open event to be removed. I don't want it to happen anymore after the new save. Can I do that programmatically? I'm very basic to this...

I'm getting an error "MSACCESS.EXE has generate errors and will be closed by Windows. You will need to restart the program. AN error log is being created." It seems to happen at the opening of a report. The report contains all the records within a table, and the error has happened while...

Hi, Is there a setting somewhere that will allow me to forward an attachment also when forwarding an email? I've looked everywhere and this has escaped me! Thanks for any help! MrsTFB

I've been READING about exporting Access records to Excel. All I need are 6 fields which will be housed on a form to be moved to a particular sheet in Excel. I took a training class and was able to accomplish this, of course now...it's not working. Here's what I'm using, any ideas? Private...

Hey, I have a fairly simple database for returns. I have 3 tables...Return Information (main table), Customer Information and Part Information. I have created a query from all three tables, however....I link the tables by CustNum and PartNum. When I run the query to [Enter Return Number], if...

Hey, I'm trying to allow the user to enter up to 4 part numbers in separate fields. I've named the PartNum, then PartNum2, PartNum3, PartNum4. The problem is that I have an information table that links with PartNum and gives the description. Of course I have Desc, then Desc2...etc. However...

Hi guys, I have a database that assigns RFQ (Request for Quote) number. What I need it to do, is find the maximum number in the RFQnum field and add 1 to it for the new record. I've achieved creating the number, but it didn't populate the new record with the new number. I'm missing something...

Hey, I need a macro or code in Access that will open a particular file in Excel, then do the SaveAs command. Is that possible? I'm thinking I can at least get to the Excel file, then I can create a VBA macro in the Excel to Save As...easier? Also, the text to name the new file, is in the Access...

Help! I created a database last year sometime in Access 97. It now needs some updates and changes. I now have Access 2000, but the user does not. I have the database on my system, but I can't make any changes to the forms or reports from here. I don't want to convert to 2000, because it will...

I'm not sure how to ask this, but here goes. I'm sending out an email about a quote that needs completed. Within THAT email is the Target Date. I have been asked to place in the reciepent's calendar, a reminder for one week PRIOR to the target date. Anyone ever done anything like that? VBA is...

Hey, I have not posted in some time, but I assume it works the same. I have a date field, that I would like to be able to calculate one week later. I'm using Excel 2000 and have say 5/14/03 in E6, in E12, I want the date to be 5/21/03. I know there is probably a formula for that, but I could...

Help please... I have an Access97 database that is used by several users. I want the data entry form and an update form to only be available to one user at a time. I have tried the Lock Records property on the forms, but it does not solve my problem, it still let the second user open the form...