Search results

Hi all, I am trying to upload excel file and then run bunch of queries to update few tables based on uploaded file. I want to have a sub that calls function(to upload excel) with two vars supplied, and function in turn returns Boolean value back to sub. So the sub can use the boolean value to...

Hello all, Getting stuck again on trying something new. I have few action queries which updates TblUsers based on imported table from HR data to addnew users and update current users. I put this action query in a VBA module(ActiveListSync) and attempting to run a VB Script to run the module...

Hi All, I started exploring the SQL statement in VBA rather than building a query and I am having issue with Update query. So basically what I want is to get a msgbox which is asking user "If you have a car or not" and based on the answer (YES/NO), I want to check off the checkbox (HasCar) in...

Hello, I have a sub form AddEditEmployee within main form Admin. Both forms are not linked and only purpose of the subform is to Add/update users. I am getting error 2450 when the AddEditEmployee form is inserted as subform in the Admin form, but when open as stand alone, it doesn't throw an...

Hello, I built the update qry which has criteria and update To fields set from the form which I am attempting to execute via VBA. When I run the VBA it throws a runtime error 3061. Not sure where the mistake is. I checked to see if there was a typo anywhere, but unable to find it. Please let...

Hi all, I have saved UpdateQry named qryvoidBlank on my FE to void blank records (not to delete). If I run query directly or via docm.openquery, it runs without any errors and makes necessary updates. However, if I use Currentdb.execute method then it kicks in error 3061 with "Too few...

Hi all, I am getting a runtime error when I am referencing a control of an open form in the module I created to print a report. I want to print a report if there is any value other than "0" in the txtbox of the form called DropAmount. I needed to create a module for the print job to be...

Hello everyone, I am sure this may be just a simple thing and may have been asked before. I found some solution to DLookup but I am not currently using DLookup so need to find another way. Below is the code I have behind BtnLogin to validate username and password. Right now it is not comparing...

Hello, Self teaching VBA and Access. So not a pro on either. somehow I was able to manage have access print two copies of the report, but now I would like to have two footers on both copies, one should say "Original" and 2nd "Duplicate". How could it be done. Searched online but couldn't...

Hello, Screaming for Help! right now. I am not an Access pro. Just know basics to develop small DBs and enough VB to do small things like printing a form. Our store uses points based system to keep track of attendance for all employee. For example, if you called out, 1 point will be assigned...

Is it possible to add two fields on separate records on the continuous form? I have a sales amount for each month displayed on the form. I would like to sum only two month at at time and display that on unbound txtbox, how can this be done? EX: 1 Jan $5000 2 Feb $6000 --- |$11000| 3...

Duplicating Sequential numeric form numbers Hello everyone, I created DB for item check in/out. Everytime item is issued, it prints the form with sequential form #. I couldn't use the Autonumber as it skips the number so used DMax to assign next number. It worked great until few days ago. Now...

I disabled the right click options and close button on the form with property setup so user doesn't close the form without completing it. Then I ran into an issue where they were just simply clicking "X" on the top of the application to close the form and relaunch the app. This was creating some...

Hi everyone, This is a great forum and community here is great. Always responds to all questions. Much much appreciated all the help I have received from everyone so far. Still a beginner here on DB and VBA. I want to build a DB that can track the cash flow of a small cash register. Just...

Hi everyone, I have a DB which runs 24/7. I would like to automate certain reports to be exported(Excel) at certain time with data and time included in report name. Is there a way to achive this from access itself without Task Scheduler? I don't have admin access so I can't schedule a task to...

In my Navigation form, I have few tabs. If user is using of the tab to enter data, and in the process(in case incorrect tab select) if user clicks on the other tab, it will create a record on the table. I would like to eliminate that since it is creating false records and I have to clean it...

Hi guys, I have finally created my first DB using everyone's help in this forum(Thanks all) and from prof. Google. DB will be multi user and used 24 hrs. It has front end and back end. Everything seems to be working great so far. Now I want to setup compact and repair function on daily basis...

Up until few minutes ago, reports were opening just fine (not the full screen but appropriate size). Now it opens up in small bar size window. How can i fix this. (Unfortunately I am unable to post picture. All the options are disabled.)

Hello, Trying to figure this out for last few hours. I am new and self taught DB. Here is the problem. DB is for Issue/Return items. Sometimes items are checkout on day1 and cheked in on day2. When an item is issued, it generates and unique Tras No, which shows as pending in a separate form...

I have two identical tables, TblReturn & TblReturnVoids. On the form there is a Void button. I would like to move selected recorded from tableTblReturn to TblReturnVoids when user clicks on Void button. I know, Void (YES/NO) is much better option but compliance wants voided records in a...