kini113
Last Activity: Sep 12 '12, 05:42 AM
Joined: Aug 18 '09
Location:
-
that helps a lot actually but one last question it seems like a long process to add just 1 .pdf file into '03 MS Access is there an easy way to do a batch, like 50 .pdf files at one time? -
Ok sorry.... Using MS Access '03, I figured the easiest option was to take what it already on the server in a file and create a table with it so I can identify it easier. I'm dealing with pieces of metal they have an OD (outer dimension), an ID (Inner dimension), a Spec code for example 655 or 20H, as well as a specific bar number for each piece of metal. One material certification (which is the .pdf file) can be for several bar numbers. I...Leave a comment:
-
Currently all of the .pdfs are stored on a file server but there is no link to my inventory database and one .pdf may apply to multiple entries in the database as well.Leave a comment:
-
Access database of .pdf files?????
I'm trying to add .pdf files for easy access to an existing inventory database, without duplicating the entry since 1 .pdf may correspond to multiple inventory entries already in the system. pdf's seem to be the hardest type of file in incorporate into an Access Database so any help would be wonderful. Am I missing something completely simple here? Thanks for your help. -
Changed it to make it a true statement and it works :) Thanks so much for your helpLeave a comment:
-
I don't get an error message with those condition syntax but it doesn't stop the macro from running even when the condition is met. Baffled....Leave a comment:
-
AutoExec Macro Help
I have 2 AutoExec macro's that run at a specified time every morning (1am) but 1 of those macros can't be run more then 1 time a day. I found a set up on a previous post that almost solves my problem, but the StopMacro condition gives me a syntax error.
Here's what i have so far...
A table named "tblLastUpd ate" with a field "DateUpdate d"
A query in the macro which will append that table with the date it runs... -
The ODBC connection is a System DSN and I can't find anywhere to save it. Let me know if I'm missing something. Is there a way to change it to a User DSN I know I can save a password there?
Stewart thanks for your info, but I must admit i'm really new to VBA and I don't understand alot of what you said. I normally work in MS Access syntax, is there anyway you could explain your previous post more simply.
Thanks...Leave a comment:
-
I can't figure out how to save a System DSN password. How would I do a trusted connection?
Thanks
CindyLeave a comment:
-
Unforunately ODBC passwords can't be saved from what I've read on other sites due to registry security. I tried the SendKey() function but it didn't work maybe it's just not in the right place to respond to the prompt for the password. Here is the what I have so far
...Code:Function Update_Inventory() On Error GoTo Update_Inventory_Err DoCmd.SetWarnings False ' Remove barstock on order from control inventoryLeave a comment:
-
How to run a scheduled AutoExec Macro that requires an ODBC password
I want to update my MS Access database every night at 10pm. I have a Macro that runs all of the queries needed to update the database (which is also saved as a VBA module) and an AutoExec Macro to runs the "Update Inventory" macro. I also scheduled the task to run every night a 10pm. The problem i have is that in order to run the "Update Inventory" macro I have to enter my ODBC password and there is no way to save the password.... -
Run an AutoExec Macro where an ODBC password is required
I want to update my database every night at 10pm. I have a Macro that runs all of the queries needed to update the database (which is also saved as a VBA module) and an AutoExec Macro to runs the "Update Inventory" macro. I also scheduled the task to run every night a 10pm. The problem i have is that in order to run the "Update Inventory" macro I have to enter my ODBC password and there is no way to save the password. This... -
Thank you so much it's perfect
CindyLeave a comment:
-
The columns shifted to left when I postedLeave a comment:
-
It didn't work can you look and see if I missed some thing
This is how the code came out with my the table name Bar Stock Inventory and column name DESCRIPTION
...Code:SELECT [Bar Stock Inventory].DESCRIPTION, Mid([Bar Stock Inventory].DESCRIPTION,1, InStr(1,[Bar Stock Inventory].DESCRIPTION,"")) AS [OD SIZE], IIf(InStr(1,[Bar Stock Inventory].DESCRIPTION,"x")<>0, Trim((Mid([Bar
Leave a comment:
-
For the OD size this is what i have and it's working great.
OD SIZE: Left([Purchase Info Bar Inventory]!DESCRIPTION,In Str([Purchase Info Bar Inventory]!DESCRIPTION,"o d")+1)
For the ID Size this is working somewhat it gives me the ID size when there is an ID size seperated by an "x" but if there is no ID size and no "x" it repeats the OD size instead of giving me a Null value ( this is...Leave a comment:
-
Yes I need SQL (within a query)
Thanks so much for your helpLeave a comment:
-
The description is for a bar of metal with an outer dimension (od) and an inner dimemsion (id). But if the bar is solid there is no id. So from that data which varies in format since it is imported from other software with no set format. I need two columns one for the od size and the other for id size and if there is no id then the field needs to be Null. If there is an "x" in the field it seperates an od and id. If there is no "x"...Leave a comment:
-
How can I get the [OD SIze] and [ID Size] from the description in lines 5 and 7?Leave a comment:
-
Lines 5 and 7 are examples of what kind of data i have but I also have a description that is (10.00" od x 7.50 id rough turned 38-43rc with certs). I don't have an "x" anywhere other then between the 2 sizes. So all the line above would be correctLeave a comment:
No activity results to display
Leave a comment: