Search results

Hi Everyone! So I have my database split and I have a couple of tables that actually drive the FE that would be maintained by me and probably changed with each FE release. Purpose of the application. It's a mini accounting system. In my travels as a self employed accountant, I found that my...

I have a combobox, cboDatabases. I am trying to load the names of Access Databases in the project's path into a combo box . When I step thru the code, I am seeing the database name, but it's not loading into the combo box. I did try to hardcode specific items into the combo box, but no...

Ok, I probably have a goofy title for this thread, but this is what I want to do. I have some fields that have a lookup to another table. For example, tblTransactions has a field name AcccountID (long) that has a lookup to tblCOA, COAID, to select the account. What I would like to do is have...

This from a liberal site. https://www.snopes.com/fact-check/trump-and-children-face-250-million-tax-evasion-charges/

Has anyone connected QuickBooks files to Access? If so, what did you use. I have Access 2019 and QuickBooks Accountant 2013. It looks like I would have to purchase an ODBC driver. Thanks

Hi Guys, I'm working on a project that would be like a mini photobooth. I copied code from two different sources (Cheap Alternative to Access Imagine and other posts). So far, so good. I did try to use AccessImagine but I couldn't get it to do what I want and it kept hanging up the database...

Ok I just downloaded this database. The only way it works on my computer is if I select option YUY2, the default choice is MJPG. Can anyone explain to me why? I also created a little database from some code I found and the same thing happened. If I pick MJPG, no image is displayed in the...

What do you use? I currently use Carbonite but creating a download takes forever, even for smaller folders way belong the maximum. I'm using brand new computers and Xfinity. Nothing else is turned on.

Hi Experts, I’m currently working on an application that shares images taken by my photobooth. By sharing, I mean the user can print, email, or text the image (still working on the texting part). For error handling, and to reduce the wait time on these requests, I’ve done the following: Email...

Hi All! I am working on a database that will share images by email. I have the email part working but I was wondering if there was a way to check for an internet connection before emailing the image. The database will be on my laptop and I will be at various places doing a photobooth and...

I did use Access 2013, just installed Access 2019, on a new computer. My old computer has an old version of Adobe Acrobat Pro, while this computer has Adobe Acrobat Reader (which may be the cause of my problem. Client computer has Acrobat Pro also). This snippet code is not creating any files...

Ok you Brits! Give my Cubbies a big welcome! They battle their archenemy, St Louis Cardinals, this Saturday and Sunday!

https://www.foxnews.com/politics/nadler-feuded-schiff-pelosi-unconstitutional-impeachment-donald-trump

My Access Database FE (accdb) has been running for several months on a Citrix Server without issue. Developed in Access 2013, Citrix Server is using Access 2016. Now we get this (when client clicked the Export button): "Execution of this application has stopped due to a run-time error: The...

I have two tables, tblPWBenefits and tblPWTable. Currently, I am extracting rates by using the County from both tables and performing a join. Works great. However, the rates on tblPWTable do change based on effective date and I want to based the extracting by using CheckDate on tblPWBenefits...

I posted on another thread about my FE having database bloat and I've implemented the following changes: 1) removed to temporary tables, so I'm no longer making tables, deleting all records, and appending to it. 2) added a routine to close all forms and reports when frmNavigation is closed 3)...

Hi, I need to create .csv files to be uploaded to a state portal. This is the code to create the .csv (it loops to create a csv for each Job) 'Note: Job is a text field in tblCPUpload rsExportSQL = "SELECT * FROM qryCPUpload " _ & "WHERE (ProjectNumber= " & "'" & Job & "' AND...

My project creates CSV, column delimited files (probably close to 40 each week and they individually have to be uploaded to our State's portal). There are several fields that have telephone number. My tables have them setup as short text. When I open the CSV file, since the column isn't wide...

Importing from Excel can save a lot of time, but cause a lot of headaches. The first spreadsheet from client used the format xxx-xxx-xxxx for the telephone number. Now they are using (xxx) xxx-xxxx. Is there a way while transfering the spreadsheet that this column can be formatted to one...

I'm not sure how it happened. I made a few changes to my database. It was about 14,000kb. Now its 650,000kb! I have it set to compact on close and lately, I've been getting a message at the right hand corner 'Compacting, Press Hold, etc' which I didn't receive before. I have not added any...