Recent content by sibleytr

Thanks PHV Here's where I went wrong: 1. Turn off Reference to Active X 2. Watch those single and double quote issues 3. For crying out load edit those variable names when using copy and paste Dim strFrmName As String Dim strSql As String Dim rs As Recordset Dim db As...

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

Thanks

Found it! Dim strSrcPth As String Dim strTrgPth As String strSql = "SELECT * FROM tblInfoPaths " strSql = strSql & "WHERE tblInfoPaths.strPathType = 'Source';" Set rs = db.OpenRecordset(strSql, dbOpenSnapshot) strSrcPth = rs!strPathDetails strSql = "SELECT * FROM tblInfoPaths " strSql =...

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 enabled the MS DAO reference and reset the Dim as DAO.<> and all is well. Thanks for the info.

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

You code good - thanks.

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

the Trim command by itself only trimed the outer ends of the data, I had to use your IIF to make it really massage the data they proper way. Thanks for the code. It is greatly apprecaited.

I don't know what my computer has been smoking but I re-ran my previous. FullStreetName: Trim([PREDIRECT] & " " & [STREETNAME] & " " & [STREETTYPE] & " " & [POSTDIRECT]) and the query worked this time. Time to crush the bugs with a format do over. Thanks again.

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

Your right it is a type-o "/" instead of "\". Sorry. When you look a something long enough it reads differently then what it is. The code works great in the Access Query. Thanks again.

I finally found the KB on it but it's turning in to be more trouble then time permits, so I attacking from the VB side. Thanks for your reply.