Search results

Bob, thanks for the response. We hid the tables and hope that this is enough. We had to distribute the product. We will get back to this when time permits. Thanks again for the response.

We have an MS Access DB that we want to restrict user access to data and only allow them to use the forms. We tried to use Run-Time access but not could make it work. Does anybody have any instructions on how to make the Access run-time work or is there any way to hide the tables. Thanks for...

I will be glad to provide, after the storm passes. For now, it works. Thanks Again for all the help.

There is no difference in orders. I cheated, I have written a quick VBA program to mark the record when the customer changes. I did not want to do this because I would have to change the program when fields change. But at least, for now, I got pass this. Thanks for the effort.

Thanks for trying. I was afraid that was going to be the answer, but I had to try. Thanks for the help.

I have two files that match on customer number and order number. Is there a way that I can identify the first line matched. For example, Customer 1 has twentry orders. I will get twenty lines of data. Is there a way to "mark" the first Order. Can not do on order number because order numbers are...

The files are close images of each other. There is only one field that was different - an error field. When the record was read, it was edited. If there was an error, the record was copied to a new table, the error was described and deleted from the original table. This is what the copying...

I am copying from one table to the other. I just got it to work. I used the rst3.Fields(dFieldName.Name) = rst.Fields(dFieldName.Name) construct. Thanks for the help

I have two tables. I have to copy one to the other using individual field names. I do not know the field names This is what I have done Dim dFieldName As Field For Each dFieldName In dbs.TableDefs!tblOracleARFeedBackErrorsRpt.Fields rst3!dFieldName.Name =...

Thanks for the help.

Is there a way to get the tcp address on which MS Access is running. I need to insure that the MS Access program can only run on a particular server. Thanks for the help.

When I import an XML File, I get these Tables 1. BSR 2. Sender 3. DateTime 4 Operamt 5. FOB 6. FTTerm 7. plus 16 others. I can update the files in access, but when I get ready to export to XML, how can I put the all the files back in the same order? Thanks in advance for helping

Thanks for all your help. I gave up and decided to "just get the job done" This is what I did dbs.Execute "Delete * from tblInvoices where trim(Invno) <> '" & Trim(Str(Me!txtInv)) & "'" Thanks again.

I am sure. I have "debugged" and seen that the passed parm have a value. I have changed the query to select nulls only (is null) and I get nothing back.

I am trying to execute a query that has a parameter. I have defined the parameter as "double" in the query(PARAMETERS SelectedInv IEEEDouble;). This is my VBA Code Dim qdfParm As QueryDef Dim ParmInv As Double ParmInv = Me!txtInv Set qdfParm = dbs.QueryDefs("qryRemoveAllInvoicesExceptSelected")...

All, I would like to find report design ideas. Creating the reports, using subreports, etc is not the problem. I would like to see reports designed by others to see what looks "good". I am sure that my designs need desperately to be changed, but I do not know what to change. Basically, I would...

It is an EDI purchase order transaction sent to the vendor as oppoed to received from a customer. It has very stringent format requirements. Most of the time is spent on getting the format correct. Thanks for asking

I need an Access Db that creates outbound EDI 850 transactions. I am mainly interested in not having to recreate the tedious record format. I would appreciate any help. Thanks for your consideration.

When the attached abbreviated code is run for the first time, it leaves Excel screen open. I have been told to clean up the code. The problem is that I do not know what to clean up. Any help would be appreicated. Thanks

Thanks. I will try your solution. Closing the app may cause user problems when more than one use is using the app. Thanks Again.