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...

Ok, there may be a better way to do this. When the StartUp form is opened, I have it check to see if 2 fonts are present on the local machine. If not, the database closes and the then copies the fonts to the c:\winnt\fonts folder. I then have the folder open to complete the installation of...

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"

Sorry for jumping the gun, but I found out how to use: DoCmd.OpenReport stDocName, acPreview, , , , OpenArgs:=

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...

Thank you for the response. It is 'bound' I am assuming. I dragged it to the form from the field list. Another related problem. When the form (continuous) opens, I evaluate a field. If it not null, then it is not enabled. It appears it is looking at the first record and then applying it to...

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...

Thank you for your help. I will see if the owner of the table will add a date field and update it each time.

Thank you for the quick response. I reviewed the table and it appears it is actually deleted and recreated every morning (if the owner remembers). The modified and create dates are the same. The data itself is not updated throughtout the day, it is only an export for multiple users to review...

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.

Thank you Bob. I hope you did not pull all of your hair out looking at the attachment. The individual checkboxes was so I could choose any combination of the 3 sites. Should I add enough checkboxes to cover the combinations and alter the IIf statement? I am linking to an existing table that...

Thank you again. I removed everything except the table, query and form that I am needing help with. When looking at it, please be gentle regarding my code. I have alot of redundant code that I need help with.

Thank you for your help Bob. Not sure if I am missing something, besides the obvious....knowledge. The criteria of the query, I have: [forms]![frmDisposition].[SiteValue] The unbound control on the form is named SiteValue The current value is "FW" Or "MA" Or "PA", but it appears it is not...

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 am already using the fOSUsername() with no trouble. I would like to use a certain table based on my site that is associated with my username/NTid. If tblSite.site="FTW", then use table tblFTW As for the mutliple tables, the record count will run into the thousands very quickly with the...

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)...