Search results

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...

What do you use as a Help System for your databases? For VB and VB.NET, I used Microsoft HTML Workshop .chm files. Can this be integrated with Access? Any other ideas? Thanks Cathy

I have a table, tblCPUpload. The two date columns have dates stored as mm/dd/yyyy without time stamp. An image of the table in datasheet view is below. PayrollStart and PayrollEnd, Date/Time columns My code to extract rows, based on project number (the code below is using Job number), and...

I created a report. I did have a field, ProjectNumber, but I removed it. The query behind the report runs without the popup: Enter Parameter Value: ProjectNumber. When I scroll down the list of controls, I don't see one that says ProjectNumber. Any Ideas? Thanks

Hi All, I am using Access 2013. I have a pdf form, that I wish to fill in via an Access report. I tried inserting an Active X object, Adobe PDF Reader. Here is my code: Private Sub Report_Load() Me.AcroPDF0.LoadFile "c:\Prevailing Wage\Certified Payroll Database\Affadivit.pdf" End Sub...

Our state has a portal to upload csv files, one for each job. We average 25-50 jobs a week. My Access database splits my table into separate csv files. In their infinite wisdom, 20 of the almost 100 columns in the template have duplicate column names, ie Address, City, etc. 1) Can I create...

I just know there has to be a simple solution. I'm using Access 2013. I have an update query that joins two tables, tblPWTable and tblPWBenefits. tblPWTable contains various rates of pay and tblPWBenefits has the hours information and calculated fields for vacation, training, etc. One field...

Hi All, I'm running a query and trying to use the External Data Export to Text File Wizard to export the query results. I've searched the Internet, and the only time I see this is when a query is referencing a Form. I've changed that to use TempVars. Here is my SQL behind the query...

Hi Everyone, I have a database that has a Navigation form. One of the forms has date fields for StartDate and EndDate for date selection. My query is using these dates for selection criteria with no problem. My problem is I want the StartDate and EndDate to display in the query results. The...

I'm Cathy. I just found this forum. I really like the layout. I'm very casual with using Access. I currently have Access 2013 and I'm starting to work with it again. I'm doing a favor for my husband and his job (and yes, I will get paid for it). Looking forward to posting with you.