Search results

Hi all, I have a very large Access application and use a hidden "main switchboard" to store data such as the current customer ID. Prior to the advent of tempvars, I embedded a key control into many query's underlying combo boxes, list boxes and forms criteria: "Forms![main...

Hi Again, Just an update - currently the form with the slider control subform is getting more useful by the day. I've got a type mismatch error 13 on initial opening in function SetReturnValue, but it seems to work fine anyway. I do have a question, forgive my lack of expertise as perhaps the...

Thank you Chris, I appreciate your help. After 20 years, I find that every time I start thinking I'm getting pretty good, someone like you comes along to humble me. This is going to be very useful in the "touch-screen" app I'm working on for Win 8 tablets. It's very frustrating that Microsoft...

Hi, and thanks Chris, I love your slider bar control. I was wondering if anyone can help me with it as I'd like to incorporate into a form and need some more control. I've got a bunch of questions, and would appreciate some guidance. In no particular order, here they are. The app has grown, so...

I hate Windows 8, but have to deal with it. Please let me know if you have any solution to this problem. I have a mobile inspections App (Access 2010) that allows users to perform inspections and then synchronize the records to a remote data file when they have a network connection. The app...

I had/have the same issue with our inspection software component. Many of our clients already own, and like iPads. I found one company currently offering a system that allows one to put an Access table structure on an iPad and wrap it with a GUI using their SDK (free). They offer a number of...

Hi - I'm not sure if there is still any interest in this, but in case someone reviews this post, I've worked out code to move attachments from one table to another, perhaps it may be of some help. The zip file is too big to upload at 20 MB, so I put a download link on our developer's page here...

This sample database shows how to output a multi-sheet, formatted Excel workbook. It also shows how to read in new data and update existing data via the spreadsheet. It's too big to upload so you can download from our developer's page here...

This sample database allows one to move attachments from one table to another and will handle multiple attachments. I could not upload the database, so I posted it here: http://www.informedcorp.com/Access-Development-developers-page.html It's the second sample down, called "Data Mover".

In case anyone stumbles on this: This software machine is running much faster now due to the kind help of Albert Kallal who corrected my inefficient technique - the inner loop of the MoveData function (where the attachments are handled) is entirely his.

Thanks Pat, I can't comment on IT folks since my degree is in Mechanical Engineering, but don't doubt you. In my profession, there seemed to be various levels of expertise, with the docs (professors and super-experts) followed by the guru class (capable of solving the messes of others) followed...

Thanks Pat, and you are correct, very insightful. Not only is this too large, I have two competitors who are cleaning chemical manufacturers, who tried to put an app like this on the web - both spent a ton or money, and both failed. One is trying again, and the other now suggests their software...

Hi and thanks for taking the time to answer and ask questions. In terms of the sheer size of this beast, I keep track of things on the about page: Currently: No. Forms/Subforms: 521 No. of Reports/Subreports: 334 No. of Queries: 3484 No of tables: 414 (many local, perhaps 90 needed on the...

Update on speed: Testing against a table with 30 fields and 1 attachment field having 132,000 records: Import the entire table via Access' built-in commands: about 10 seconds Append all records (omitting the attachment field) via a query: ~10 seconds Move records via new code, including...

Just a quick note: The savetodisk/loadfile method I used turns out to be inefficient (slow). Albert Kallel, showed me a better way via transfer directly from one table to another. I uploaded an update to my developers page (home page of informedcorp.com, then click the developer's page link at...

Access' attachment feature is very useful if the total number of attachments times their typical sizes aren't large. I use a mix of both techniques since my software ships with about 7000 images (all those private labels). The huge number of images and the lack of the attachment feature forced...

Hi Rookie, I develop and sell an Access 2010 solution for a niche market and have observed that as soon as we put a back end on a network performance drops considerably as compared to a purely local installation. I'd guess it averages about 3X - 10X faster locally than over a network. The...

Well, one way to quickly test is: 1. Rename the source and target tables in the sample database 2. Import the two tables you're concerned with (your source and your target) 3. Rename the two tables imported to "sourcetable" and "targettable" 4. The subforms in frmDataMover will not show...

Oh, I know the problems. I'm just amazed the next higher tier of programmers didn't come up with this earlier. In retrospect it would seem to be fairly trivial for a guru to do. I'm getting there, but don't consider myself a guru. I get things done through persistence and just never giving up...

Hi Kelanen, you're in luck! I just developed code and a sample database that does exactly what you are looking for. The code allows one to call a function and pass the names of the source and target tables, as well as, optionally, the name of an attachment field. It then creates a table...