Microsoft Access / VBA Forum

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check https://www.worldtimebuddy.com/ ...

Hi I am trying to import a text file into a MS Access database. The first 11 lines of the text file are in a different format, so i would like to skip those lines and start at line 12. is there a quick and easy way to skip lines using VB in Access. Here is a sample of my text file: SDS 2.2 AD Results 1.0 Filename PlateID Assay...

Hi all, I have a child and parent forms. The record source of the sub-form is query containing aggregate functions. A combo box in the parent form filters the sub-form results based on value (name) selected. Some values of the sub-form are accessed and displayed on the main form; A calculation is done (using values of the sub form)and...

Hi all, I need some help with a VBA code. I have tried differents codes that i fund in the forum but they didn t match with what i m looking for. So i will explain what i have , what i need and what i expect. I have a workbook with 2 sheets (Sheet1 , Sheet2). Both sheets have values in columns A to F. (A:F). Values Start at A2. B2..... etc...

In my report, I have 2 weight fields. Sometimes there will only be a value in the first field and then a "0" in the field. Rather than showing the "0" in the report, I would like the field to be blank/empty. If I change the criteria for at the query level to >0, nothing shows up on the report. Thanks for your help.

This thread is a response to a very popular thread (How to convert Text dates to Date format?) which is locked down now so I thought I'd reply separately. This should be considered as a continuation of the topic where, hopefully, I can clarify any confusion. Always bear in mind that date values and date literals are completely different...

Although some users find Macros simple and easy to use, there are some major limitations to using them. Although you can use macros to perform tasks, there is limited control on when and how those tasks should be performed, and setting conditions can be difficult. There is however, another even stronger reason not to use macros and that is that...

I am so frustrated - any help is appreciated. When trying to use common functions like Left and/or Mid I get the following error: Run-time Error '5': Invalid Procedure Call or Argument In my searches it appears I am not the first, but the solution seems to be missing references. When I check my references, none are labelled as missing....

Hi, Is it possible to use a users windows logon details to log into an access database? So for example Bob.Smith logs onto windows he then opens an access database the database checks that he has a user account and permissions setup within access if he does the database logs him in and then applies those permissions to the access database. ...

I my form I have put record navigation buttons. When I choose just before the last record, the "Go to next record" button, access automatically start with a new record instead of a message that theere are no records after. I do have a command that automatically jumps to the last record after I open the form: Private Sub Form_Load()...

I have a form, 'frmProviderMain' with a macro which opens another form, frmEnrollmentProcessing.The macro is located on a tab on 'frmProviderMain.' I would like one of the controls/fields on the secondary form, specifically ., to fill in based on the selected provider on 'frmProviderMain'. I attempted to set an event procedure which would set...

Hi guys, I get the "System Resource Exceeded" error when I run a report, but the query which it is based on runs ok (take about 1.5 mins to run tho). Anyone have any suggestions on how to avoid this error/use less resource? Much appreciated.

I have created a database to track employee time. Within that, I have also created a report off the following query: SELECT ALLTasksFilter.ProjectName, Sum(.NumberOfCompletions) AS SumOfNumberOfCompletions, Sum(.HoursWorked) AS SumOfHoursWorked, .WorkedByWho FROM ALLTasksFilter LEFT JOIN ON ALLTasksFilter.ProjectName = .ProjectName

I have several forms stored in pdf format. Instead of scanning these forms and using them in reports, I would like to create a background in an access report to place the fields but have it actually print out onto the pdf form file. The form loses resolution if scanned and used in an access report. Thank you in advance for your help. ...

I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent to them so they can answer the questions. Once finished answering the questions, the user would return lesson 1 and we send them lesson 2. As the...

Hi, I'm new to this forum. i'd like to setup a macro to run a query daily. Is there any way in access to do this? thanks, todd

Hello everyone, I am trying to insert a picture in an excel spreadsheet cell using Access VBA. The following excel VBA code is working perfectly fine and I am able to insert picture in "A1" cell. But with the following Access VBA code, I am getting "Type Mismatch" error at line #13. Please kindly let me know how to solve this issue. ...

Hi y'all Can I reference a cell in an access table within a VBA code?? I have 1 x 2 table (1 row and 2 columns). The first column is just an autoID generator. The second column keeps track of dates. I want to write a VB code that changes the table record in row 1, column 2 of the table, tblDate. The field name is ChngDate Here's my code: ...

Hi - I'm trying to run a query as part of a VBA procedure, and what I want it to do is to grab the value for a parameter (the current month) from another part of the procedure. I clearly am missing something, however. Here's what I have: Dim db As Database Dim rs As Recordset Dim rs2 As Recordset

Hello Does anyone know what owc10.dll does? In Access XP is a reference by default to owc10.dll. I know is 'Office Web Components' or something like this. I'm asking this because after applying Office XP SP3 on the development computer and deploying to users of Access XP without SP3 applied, or users of Access 2003 without SP1, there are...

I have a field that retrieves information from an expression in a query. I have used a DLookup function to get the calculated field from the query. However, the relationship is 1-to-many so one site could have many units. How do I have the DLookUp field value change to a newly calcuated field when I navigate through the units? please see...

TIA! I would like to know if there is a way to dynamically change the colors of Subform items? I have already set in place Conditional Formatting so each row has an alernating color scheme, but what I am looking for is a way <behind a button click event> to dynamically change the Subform's color scheme so the listing can have color choices....

I have an Oracle 10g R2 database where my ERP transactions reside. I'm using MS Access to grant access to my power users where I use MS Access' Link Tables to provide direct access. I noticed that not all tables in all schema in the database is retrieved by MS Access even if SYSTEM is used to login. It looks like there's an upper limit to the...

I am just getting started with VBA and I'd appreciate any help anyone can offer here. I am trying to use VBA to look through the "Curr Year" column in table "tblYear" and check whether the value "2006" is in any of the fields for that column. Here's the code I have so far... Private Sub UpCurYr_Click() Dim db As Database Dim tdf As...

So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Navigate "whatsapp://send?phone=" & Me.Mobile & "&text=" & "Welcome! Admission of " & " " & Me.StudentName & " " & Me.Prefix & " "...