Search results

I am trying to accomplish in access VBA (or update query?) the same result as using the Excel FIND(). Excel: In Cell A1, I have a network location that I need to get the last folder (last folder name will vary in length) Formula in B1...

I did not know where to ask this question or how to ask, so please excuse me. We have an Access 2007 database that updates an Access 2003 database. My problem is, the data in 2007 is formatted and when the 2003 table is updated, it displays the html formatting tags. Is there a way to remove...

When the startup form is opened, I have code that checks to see if a file exists. If it does not, then it will be copied to the local computer. Problem is, the path contains a space. How do I account for this? When I change source to one without a space, it works fine. I do not have control...

I use the following to open a window in Windows XP. How can I close it through VB? Dim oShell Set oShell = CreateObject("Wscript.Shell") oShell.Run "explorer c:\winnt\fonts"

When opening a report from a form, I would like to sort the report by a certain field. I am using: DoCmd.OpenReport stDocName, acPreview and am not sure where the OrderBy = "field_name" goes.

Is it possible to open a form and have it use a certain table? Instead of going into the form properties and specifying the table there, can it be done using the docmd.open command? I have 2 identical tables that serve different purposes and based on what is enter in the lookup form would...

I have a continuous form with a checkbox with each record. When the checkbox is clicked, I have [Item_Num] evaluated. If the field is blank, another form pops up. Is it possible to reference the field value ([Item_Num]) of the record? I can get it to work when displaying only 1 record at a...

Is it possible to retrieve the date modified from a table? The table in question is updated from numerous sources and I would like to display the date on a form/report so the users know how old the data is.

Not sure if I am asking the right question, but.... I would like to pass a string variable to a query but it does not seem to work. In the query, my criteria for the date field is (and works): >=[forms]![frmDisposition]![FromDate] And <=[forms]![frmDisposition]![ToDate] But, this is not...

I have a table with username and site association (username: TimE, site: FTW). I have the code to determine the NTid which will be the same in the table. When I log on, I want my forms and queries to use certain tables (site specific). Is this possible?

Before everyone starts blasting me for posting ANOTHER audit question.... Is it possible to audit the activity at the "Database Window"? I have not locked the users out yet and someone deleted a table (I know, please don't rub it in). It would be nice to see who (I have the current user code)...

I would like to check if a value already exists in a table BEFORE I insert it (using VBA). Can it be done (and recommended)?

1) I would like to pass the value of an inputbox to a sql statment: 2) The "If IsNull(stAuthDocIn) Then" is not working, how should it be done? Private Sub AuthDocIn() Dim stAuthDocIn stAuthDocIn = InputBox("Please enter the authorizing document #.", "AUTHORIZING DOCUMENT") If...

I am using the following code but it will not close the form. Any idea what may cause it not to work? Private Sub cmdAddNewExit_Click() On Error GoTo Err_cmdAddNewExit_Click DoCmd.Close Exit_cmdAddNewExit_Click: Exit Sub Err_cmdAddNewExit_Click: MsgBox Err.DESCRIPTION Resume...

Not sure if this is the right section (vb code?) I am using a form to search for an item (using vb stSQL and stWHERE statement to pull from a table). If found, it will display certain fields. Once found and displayed, I would then like the option of adding this record to another table. If...

Is it possible to have a count of all records matching a certain criteria displayed on the form? I have to schedule customers for certain dates but never know how many have been scheduled by date while in the form. I am not sure how to reference the field from the table to be counted. I have...

Sorry to bother everyone with something that is probably real simple.... I would like to disable one control if another does not equal a certain value. Do I set the control to enable=No and then use OnCurrent and afterupdate? As always, I am confused and could use some assistance. Tim E.

How do I display a count based on a criteria? For example, I have =Count([Type]) which of course will display a total of the records based on field [Type]. But now I want to count all the records by field [Type] if [Size]="x". Can you point me in the right direction? As always, thank you...

Do not print an object if field is blank in table Not sure if it is possible to do, but can you not have an object (a line for example) print if a field is null?

Sorry if I may have missed it or searched incorrectly. I have an access frontend to a SQL database. I can get the datetime stamp to work when a new record is created, but I would like to also datetime stamp AND be able to "user" stamp when a single 'field' has changed within the same record...