Search results for query: *

I'm creating a template MDB for a number of upcoming projects. My current issue is to make my forms more dynamic, in that I will allow the user fill in the name of the form's title and subtitle labels. TBL name is: tblInfoFrmTitles strFrmName strFrmTitle strFrmSubTitle Dim strSql As...

Access Sql Statement Path Information I would like to be able to read information from an access table in order to deremine where to copy a file from and where to copy the file to. Currently eveything works except I have the Source and Target information hard coded. Through a serious of Combo...

Currently I have a flat MDB that I track my network storage items in. It's a simple MDB used to create tbl's, frm's and rpt's. The Tbl's contain my Server and Max storage information and then I take a manual reading and data input of each server and it's remaining space reading. What I'm...

I have an Access MDB (FE) that connects to multiple Access MDB (BE) data tables. The BE MDBs all have the same number of tables and names. In order to link to the different BE MDBs I have a comboBox that list the various BE MDB names and their locations (this table is stored in the FE MDB) and...

Whenever the FE of my MDB loads it asks for a project to manage. Depending on the project, and it's location, it will delete the existing link and then connect to the needed BE link table. However I have a situtaion where sometimes the linked table is not present to delete and thus the code...

I am needing to build a field using the data from four other fields using an Access Query. strFullStName: [PREDIRECT]&" "&[STREETNAME]&" "&[STREETTYPE]&" "&[POSTDIRECT] From the above code you can see the problem if any field, specificly the outer two fields are empty I wind up with a space...

Whenever I update a table I would like a record set that will fill in the current Date(). That's the easy part. I want to take a given Date() = 2/3/2005 and add leading "0"'s well as split the Date into two fields. So the date #2/3/2005# result would be: 02-03 2005 Any ideas?

I want to obtain all data from a string that is to the left of a givem character. The data string is a network path: "2005-A\AAA00001" I want to get all data to the left of the "\" character. I can use the Left(text,6) command but the folder name has the possiblity of changing character...

I have a series of Text files that I need to read into an Access Table. I've used DoCmd.transferDatabase in the past to import data from a single Mdb however the DoCmd.TransferText acImportFixed is kicking my butt. Especially the SpecificationName element and the need to scan multiple files...

In the past I've used the DoCmd.TrasferDatabase acLink, "Microsoft Database" fieldName.Value &"\db.Mdb", acTable, "fieldName", "fieldName" command to link to Mdbs in different project folders. This was accomplished with a table contanining the path of the different project folders, a form...