Search results

Thank you SJ, That worked perfectly !

Thanks for the replys. I can't use the right function, because the field length to the right of the delimiter ":" is not always the same length. But I will try Waynes example, which looks like it is what I need. If worse comes to worse I can do it on the form using a VBA split function, but...

Does anyone know how I could split a field in a query. I have one field that is something like this "code:567.90". I want to create another field in the same query that splits that field and only returns the value to the right of the colon (i.e. "567.90"). I have looked at the right, mid...

Hi everyone, I am looking to create a pretty simple chart on two data fields. My problem is that I need to do it from a continous form with multiple records, so there is not alot of room to place the chart. I just don't have enough room to insert a chart on the current form. I was thinking...

Just to save you some time. I've already tried: - Written queries to edit the "Database" field in the MSYSObjects table, where there is a "foreign" value. This was no good do to a read only status of the table. - Written code using ADO to open the try to modify the table data without actually...

Scott, Did you ever find a way to edit the msysobjects table? I am having the same issue now jackson

You definately need an ODBC driver installed before you can link from your frontend. But Microsoft Access automatically installs the Microsoft SQL Server ODBC driver (Sqlsrv32.dll), the Microsoft FoxPro ODBC driver (vfpodbc.dll), the Oracle ODBC driver (msorcl32.dll), and some ODBC support...

Thanks Pat ! I will do some research on that.

I knew someone was going to say that to me, but I was just wondering if anyone had done it. I was actually just looking to change the [database]field for records that had [foreignname] values. Basically, i wanted to manually change the linked table information to allow me to pre-package the...

Thanks !

Hi Folks I spoke too soon. Seems I am unable to actually edit fields within that file. I even checked for permissions and signed in as the owner of the table. When I view the table, it shows up as faded. I was trying to create an update query that would change the "Database" field within the...

I didn't have time to read everyones respones, but aside from checking the shared and security permissions on both the folder and the access file, I would make sure that everyone on that network is signing in under a unique user name in regard to both access system.mdw file as well as their...

To deploy without the end-user having MS Access on their computer, you do need to package the program using MS Office Developer to create a runtime version. If the end-user has MS access loaded on ther computer, you could compile the database into a MDE file. This will remove your source...

Write an Append Query and include that field with a criteria. Create a command button that runs the query, and reference a field on your form in the query criteria that has the value you want to use as your filter.

Great discussion point ! I agree with everything said, it really depends on the scope of your project. Since they have already talked about the upsides of web based, Here are ome positives on an Access "server based" vs "Browser based" systems : - You don't have to worry about your cable...

First you need to use the File / Get external data / link tables menu to link to external table data. good Luck !

Ok Thanks !

Hi, Has anyone every had a problem linking a frontend database to multiple backends ? I have a FE / BE database, and would like to split out a table or two into their own databases due to file size reasons. It seems to work fine, but I thought I would just ask if anyone have ever had a...

Hi Everyone, I found it. It's MsysObjects table. I just needed to view the system objets and hiddden files in the database. Thanks anyway

Yes, It should be under TOOLS / DATABASE UTILITIES / LINKED TABLE MANAGER You do have to make sure the linked table manager was installed on installation. If not, the system should prompt you to install when you use it. Good Luck