tuxalot
Last Activity: Jan 21 '13, 07:19 PM
Joined: Feb 1 '09
Location:
-
Went to a dev and got the apk coded. Works a treat! -
CD Tom:
This is how I call it:
...Code:Dim mzipfile As khZip Dim strSavePath, strZipDir As String strZipDir = BrowseFolder("Next - Choose Folder For Export") MyZipFileName = <your file name here> Set mzipfile = New khZip With mzipfile .ZipFilePath = strZipDir & "\" & MyZipFileName 'save full path to zip for emailLeave a comment:
-
First you need to unzip your files.
From your VBA editor: click file menu --> import file
From Access 2010 (different in earlier versions): click external data menu, from the import and link panel, select Access. In this screen you want to import, not link to the files. Navigate to your files and select.Leave a comment:
-
Here you go. So you will be inserting one standard module and three class modules. Study how this works and if you need assistance let me know. My implementation exports 3 tables as XML to a temp directory, zips them, deletes the individual XML files and emails the zip file. Bytes users helped me get it setup....Leave a comment:
-
Have a look at basZip by Ken Jensen. It works quite well. Requires four modules:
basZip
(classes)
khZip
khZipFile
khZipFilesLeave a comment:
-
Figured it out. I added a fourth condition in the query builder:
...Code:WHERE (((tblSrvRspns.SurveyComplete)= IIf(tblPrefs.ShowOnlyUnfinalized=1,False))) Or (((tblSrvRspns.SurveyComplete)= IIf(tblPrefs.ShowOnlyUnfinalized=2,True))) Or (((tblSrvRspns.SurveyComplete)= IIf(tblPrefs.ShowOnlyUnfinalized=3,False))) Or (((tblSrvRspns.SurveyComplete)= IIf(tblPrefs.ShowOnlyUnfinalized=
Leave a comment:
-
Evaluate boolean value in where clause
I have tblPrefs to allow users to set preferences. Option group [tblPrefs].[ShowOnlyUnfinal ized] has three choices:
1 = unfinalized
2 = finalized
3 = both
I have a boolean value at [tblSrvRspns].[SurveyComplete], for finalized and unfinalized records. I am trying to query the table and I cannot figure out how to pull out both unfinalized and finalized records (option 3 above). If a users selects option... -
Access split DB slow when working on form in design view
Seems fairly common with split DB's. Opening a form or report in design view slows processing to a crawl. Selecting an object ramps your computer CPU to 100% briefly while the computer hangs preventing any further action in Access. Your Windows task manager shows the Access app swallowing CPU cycles like a drunken sailor. Your mouse may disappear in Access or show an hourglass. Navigating to other open programs or back to your desktop may still be... -
The light bulb is on. I see. The key part of that understanding in my pea sized brain is that we are updating to a VALUE, and this process does not indicate directionality of the update to a TABLE.
Got it.
Thanks for the education.Leave a comment:
-
Thanks Smiley. Now I've changed the select query to an update query and it's working, although it seems bass-ak-wards what I had to do to make it work. Here is the SQL:
...Code:UPDATE tblResponses INNER JOIN tblAndroid ON (tblResponses.RspnsID = tblAndroid.RspnsID) AND (tblResponses.QstnID = tblAndroid.QstnID) SET tblResponses.Rspns = [tblAndroid].[Rspns], tblResponses.RspnsComment
Leave a comment:
-
Thanks for the nudge Smiley. I added appropriate joins and it is working. Here is the code:
...Code:SELECT DISTINCT tblAndroid.RspnsID, tblAndroid.QstnID, tblAndroid.Rspns, tblAndroid.RspnsComment, tblAndroid.AnswerTIme, tblAndroid.ImgPath FROM tblAndroid INNER JOIN tblResponses ON (tblResponses.QstnID = tblAndroid.QstnID) AND (tblAndroid.RspnsID = tblResponses.RspnsID)
Leave a comment:
-
Thanks all for your assistance. Smiley, I have tried running the code joining on RspnsID as that field is shared by both tables and still no good. Let me provide some background. Maybe there is an easier approach to what I am looking to accomplish.
Background: I am having an Android app developed for my survey database built in Access. Once a survey is begun, data is uploaded to a SQL table using ODBC. Android users can download data...Leave a comment:
-
Comparing dates - Access and SQL
I have an Access table with a DATETIME field. The field is not formatted as general, I left it as default (blank)
I have created a SQL table on the web using ODBC by exporting my table. That field is also DATETIME.
When viewing the dates, I see that:
Access is storing data like this:
11/26/2012 4:27:39 PM
I am learning that this is just how it appears, and that Access actually stores... -
Android app as front end for Access database
I have a functioning survey database written in Access. I would like develop an Android app that would give my auditors the ability to complete their surveys using their mobile devices. Currently the backend of the database resides locally on each of their laptops. So the workflow would be to update a web based SQL table with a survey and once complete, to sync that data back to the local laptop. This would be an Access question and I could probably... -
Doesn't Office 2010 have native PDF support? Seems you are taking the long way around but perhaps you have not explained your needs fully.Leave a comment:
-
I may just end up buying a camera with MSC functionality. But I would still like to see if my trusty Nikon L22 can work somehow. Have you had any time S7 to move forward on this? The stars outside are waiting ;)Leave a comment:
-
Very nice S7. I am looking forward to seeing what you come up with - Your knowledge and understanding about how to get this done is far better than mine.Leave a comment:
-
Correct S7, that is the WIA download.Leave a comment:
-
I've established that the procedure above will activate a camera and save the pic to the SD card of the camera in XP and W7. I need code that can find the most recent saved file in a directory of my cameras' SD card (would be the current image), and save that path to an Access table. Seems doable, but the code below fails at line #13 (explanation follows):
...Code:Public Function GetMostRecentFile() Dim FileSys As FileSystemObjectLeave a comment:
-
Thanks NeoPa. I appreciate all you do. The bashing I get from you from time to time is clearly deserved. I WILL get this. I am just a bit dense at times ;)Leave a comment:
No activity results to display
Leave a comment: