Recent content by djlysuc

Thanks, found it. It's 385.

Can anyone help me with the FaceID for the Fx Function Button Image in the insert menu? Can't seem to find it. Thanks.

Thanks Ancalima.

I am struglling with a query, although I may be going about it in the wrong way, so any help or points in the right direction is appreciated. I have an import process that creates a table with a text field like below: raw 12345A 15432B 61451C I have another table that has the conversion...

Thanks Allan. Working fine now. Querys still working with the delete and add links.

Hi, Im looking for some help on a change to a Linked table. I have a database with tables for each month (Jan,Feb,Mar etc). The structure of each tabe is the same. In another database I use this data in a query, but I need to amend the link to other months sometimes. I have found details how...

Thanks Mark. It must be Monday, I didn't think of doing it that way.

Hi, Im looking for a way to remove the file name from a string to use the ChDir statement in vb?? convert: C:\dir1\dir2\myfile.exe to: C:\dir1\dir2 Any help will be appreciated. Thanks.

Is there an easy way to get user input like the parameter value box in an update query, where you want the user to specify the table name and field name to run the query on?

Thanks Jon, I can see my stupid mistake now!

I have a text column of alpha-numeric fields and some start P123456, P111111, P222222 etc. I want to remove the P from these fields. I thought the following update query would do this but gives a type conversion error, regardless if the new column to copy them to is type text or number. Can...