Recent content by rgwfly

Thank you, After some research. I really think I was over complicating this. I ended up creating a hidden form which opens in the background by autoexec. This was so easy to do. I did notice a bit of speed increase on my Win 7 matching. but the Win 10 clients are still very slow. I may...

Ok I found different code to run. I set up a public function. I am trying to call this on the main form opening but it keeps erroring our. "Object Not found" Any help here? Public Sub proPConn(booLink As Boolean) Dim stFileName As String stFileName = stpath &...

OK I did a bit of research on the persistent connection. I installed a code that should run it on the open form event. However I am not sure it is working. I would expect to see the record locking of the back end to stay locked. Not seeing this. I will look at the link from CJ Yes am on the...

I am not familiar with the persistent connection. I will do a bit of research.

OK did some searching but cannot find anything that's worked so far. I created accdb with backend tables. converted to accde for users. Problem is their forms are really slow to load and take forever. I've narrowed it down to I am running Windows 7 but the end clients are running Windows 10 -...

OK was not sure if this is the best place to post this. I had another thread where I wanted to concatenate records together on a query and form. I used Allen Browne's method mentioned. http://allenbrowne.com/func-concat.html I was able to get this to work well in the queries. The problem I have...

OK seems to work in a independent query. I am using this for a form with a text box search. I noticed the form slowed significantly using Allen Brownes VBA. If I create a table and run the query off of that it runs much better. I now just have to figure how to update the table on form loads...

Edit: OK I think I have it, there was a null field in the underlying table. I added a where clause and it runs without the error. Funny in the original table I don't see the null value. :o

Still get the error. Something in my group by. if I remove it runs OK.

OK, I did use the code from Allen Browne above. I used in a SQL query as mentioned using I keep getting a Error "Syntax error (missing operator) in query expression". However it does run. I would like to be able to get this in a simple select query but cannot get the argument to work. "Maybe...

Hello, I have two tables in a one to many relationship. tbl_Test & tbl_tech I may have several Tech's working on one test. I was trying to get a query where I have one record from tbl_Test with the tech ID's show in a single text field. For instance: tbl_test ID tbl_tech 100 W1...

Yes I did. This puts different values (1,2,3) on each option instead of a true false. I should have used this on initial design.

I searched and sure the answer is there. I have a sub-form with multiple checkboxes. Would like to select one and only one. I know I can set the on OnClick event to clear the others. I was curious if there is a better way.

If you use the wizard just be careful in your data types. I usually use text type for everything except where calculations need to be performed. More than once I had to redo it because I imported one field as text and the other as a double only to get the dreaded mismatch data type in a query.

I usually export the SAP data into a text file and then link to the database. I found sometimes the excel export from SAP caused errors. Then you can just overwrite the same file when you do future exports. There may be better ways doing it out there. In SAP I use variants and defined layouts...