Search results

Does anyone know how to get the address of a cell identified by vlookup? For example, if Vlookup(Key, Range, COl#,false) points to cell C4, I need to return C4 (or $C$4). The vlookup range is in another spreadsheet, if that makes a difference.

Is there a keyboard shortcut to move from the Properties listing back to the form in edit mode? Thanks!

I have a model db (Access front end, sql back, linked tables). I need to be able to change input masks at the table level in code. Any ideas? Thanks!

I need to requery a subform from a third form and can't seem to get it to work. frmForm1 has frmAddress as a subform. The button cmdReviseAddress opens the form frmUpdateAddress where all of my validation work is done and the new record is added. However, the new address is not being...

I can't find the file dsn for an Access DB. I can refresh the tables, and I've looked for all of the *.dsn files on the drives where it might be and I can't seem to find it. Is there any way to get the location of a file dsn from the linked table? Thanks!

I have an Access 2000 database that gives me the following error when I try to Compact and Repair or build an mde: Could not find field 'Description'. When I click on help I am directed to Jet Error Message 3799, which is not helpful. I tried pulling over objects a few at a time into a new...

I've got an Access 2000 db that gives the error message "The Visual Basic for Applications project in the database is corrupt" when I try to view the VB code. After receiving the error message, closing the form window causes an Access Dr. Watson error. I can't import from or export out of...

I'm trying to set up a queue for a form: The table has a field called AccessStatus that is "0" if the record is available, "1" if it is not. I'm trying to set the AccessStatus to "1" as soon as the form is opened, so that no one else can get it. Here's the code: Private Sub Form_Open(Cancel...

Here's the problem: I'm trying to enter a value on form1 and have form2 open to that record, but be able to navigate to records before & after the target record. Here's the code I'm using: ******************************** Private Sub Form_Open(Cancel As Integer) Dim strTgt As String...

Here's my code: Private Sub test_Click() On Error GoTo Err_test_Click Dim dbs As Database, rst As Recordset, intRecordCount As Integer Set dbs = CurrentDb Set rst = dbs.OpenRecordset("qryQCMainSizeCheck", dbOpenDynaset) I get the following error message: "Too few parameters. Expected 1."...

I'm having a strange problem with a totals query. I have an address table containing (among others) the following fields: RecID (the link with the master table), Generation, and id1, an autonumber field. Every time a new record is added for a given RecID, the generation number is...

I'm having a problem with relationships disappearing from queries. Table1 has the field RecID. Table2 has the fields RecID, Generation, and other data. The generation number is incremented each time updated data is appended for a given RecID. The tables are linked by a 1-many relationship...

Is there a way to pause VB execution while an external program runs? My code does some stuff, runs a Visual FoxPro executable, and does more stuff with the result. I want VB to stop until VFP is done. I can use a message box that instructs the user to push a button when VFP is finished, but...

I have a report that I would like to get into Word so that I can email it to a client that does not have Access. Each field is surrounded by a border, which is lost when publishing to Word. Is there anotehr way to get this into Word? tia fmm

This is a strange one: Assume that the following directory is empty: R:\claims\projects\xxxxx xxxxx\data\V F P 12 If I try to execute the following command in VBA, it works fine: DoCmd.TransferSpreadsheet acExport, , "tblReturnedMail", "R:\claims\projects\xxxxx xxxxx\data\V F P 1234567890...

I'm working in Acess 2000 and I am having trouble importing a form. If I try to import or export the form I get the following message: "Name conflicts with existing module, project, or object library." I can rename the form to a string of random characters and I get the same message. Both...

I am having trouble copying data from one subform to another (Access 2000). Here's the setup: The subform frmPurchaseSubform has a field called SerialNumber. The subform frmSale Subform has fields Transfer Name and Transfer Serial Number. After I enter data in Transfer Name, I need the...