Search results for query: *

Thanks for sharing that. I'll use what I can and keep it for future reference.

Can anyone point me to some code that they use successfully that will check to see if Word is open, if not, open it. Then, check to see if a specific document is open and if not, open it. Can't seem to do this cleanly. Any help is appreciated.

Can you point me to an example of that code? Thanks.

How can I pass data to a .txt file. For example, I want a file named (fieldname).txt. I want to write data to it: Name: data Address: data Hope that makes sense. Any help is appreciated.

Can I join three tables and update fields from all? Thanks.

Thank you.

In a hidden field on the form? Hate to ask a dumb question, but how do I declare public variables? I tried that and it didn't work - I did below: Public Sub Variables() Dim sUserLoc As String Dim sUserLocfullname As String Dim sFolderLoc As String Dim sFolderLocfullname As String Dim...

I don't have the variables when I click cmdProcess. I get them on an after update of a text box, then do cmdProcess. Thanks.

This is the code I use the update the data. (I concatenate two strings). But at this point my variables are gone. Private Sub cmdProcess_Click() On Error GoTo ErrorHandler: Dim sUserLoc As String Dim sUserLocfullname As String Dim sFolderLoc As String Dim sFolderLocfullname As String Dim...

I'm dimming some variables in the general declarations area of a form. On the after update of a text box I use the variables successfully to collect data in a SQL update string. Then the user has to click on a button to update the data to the database. But at that point I don't have the...

That worked great. Thank you!

Do all your users have r/w privileges on the network drive where the data is stored? If any one of them has read only, for starters, when they log on they can't write to the .ldb file and I've seen that cause the problem you've described - everybody gets locked out. Fran

I have the below code, that loops through a data grid and writes a SQL string for each row. I need to concatenate all the SQL strings that get created into one string for later update to the database. Can anyone help me with that? Any help appreciated. Thanks. 'Loop through the grid For...

I have a problem and this is how I think I need to solve it: I have a grid that gets populate one record at a time by the user with a button click. I need to update the database with the contents of the grid. I think I need to get the data from the grid, populate a variable with the data and...

I have a form with a field box and a third party grid control. Data is keyed into the field and then updates the grid, resulting in a list of data in the grid. Grid name is ssQueued. Can someone point me to some code that will update the database with the data that's in the grid. Any help...

Great, that worked. Now how do I handle nulls? Thanks!!

I get error Update or CancelUpdate without Add New or Edit Runtime error 3020 Thanks for your help

I took a stab with the below, which I found here. But I need to look at every field, so I know I'm off. Function PrintableString() Dim db As DAO.Database Dim strsql As String Dim rs As DAO.Recordset Dim i As Integer Dim b As String Set db = CurrentDb strsql = "Select * from table2" Set rs...

I'm trying to clean up a data file. Is there a way in code to replace spaces with tabs? Thanks for any help.

Thanks, I'm getting an ODBC error that instr is not a recognized function name.