Microsoft Access / VBA Forum

Oh dear, I thought I understood how dates are kept and manipulated in Access, but this one has me beat. I have a subform based on a table "Team_Selection_Notes" which has three fields: PersonID (Number - the link field) NoteDate (Date/Time) and Comment (Short text)). In the subform I want to display only those notes for a person that are...

09/22/2015 Update: A bug was found in the code. The code block has been updated with the fixed code. Description RC4 is one of the most widely used ciphers in the world. It is used in WEP, WPA, SSL, BitTorrent, PDF, etc. It is one of the simplest to understand and implement. It is also one of the fastest algorithms available. What is RC4...

Sorry for lack of details, this is very new to me. I have a large dataset. There is a table that has a column with the checkbox option. The table is created in the module's code. Some options in the table are selected with the checkbox and some are not. I want the records that are selected (checked) to be processed. My module runs on all the...

Hi, Is it possible to export the design of a table to Excel (e.g. Field Names, Data Types, Descriptions)? Thanks, Laura

Can anyone explain this error. I have the following code in a button on a form Private Sub cmdExit_Click() DoCmd.Close acForm, "ActivityMaintenance" End Sub

Hello forum! I have this question: I have a query with a column that uses this criteria: (IIfCustomerType()<>3,fCustomerType()) where fCustomerType() is a function result. But this criteria isn't enough because I also need a proper else condition that will show all the results. How do I write it?... I tried: ...

Experts: I need some assistance with identifying a process flaw in an overall well-working function. Allow me to provide some background first. Background: - I need to compare two (2) tables: "Before" and "After". - Initially, the "After" table is a replica of the "Before" table. - At some point records will be updated only in the...

I am writing code in VBA in Access. I need to filtered a data set. I am brand new to this so I apologize in advance if this isn't clear. qryFilter is the query that creates a table "Filter" that only has the filtered data. BuildExhibits is the public function that I need to run with the new filtered table. Public Function InuputData() ...

When I am trying to import a .csv into a table in access somehow it is wanting to match my columns not by name but by F1-F41 or the excel sheet. How can I get it to only match on column names that are defined in the excel sheet on the first row? This is a .csv file I am trying to import. So right now I am just having excel create it's own table...

Trying to open a report with multiple WHEREconditions. I have 4 strings (SelA, SelB, SelC, whereStr) all defined as strings. SelA, SelB SelC all pieces of the whereStr If I set whereStr = {any of the individual strings A,B or C}, the following works DoCmd.OpenReport "rptName", acViewReport , , whereStr When I try to concatenate the...

I've got a query that I'm using to track if certain tasks are completed. A task is completed based on different fields being populated. I have a table that lists which field to look for. My current solution is to use a public function to determine which field to look for and then check if there is a value in that field. The only issue is that...

Hi, I am working on a project using Access 2013. I have a Leave table that calculate leave days,balance leave days,used leave days, unpaid leave days. i have created it in excel and working fine. but i could not execute in access. i hoping that someone cam help me. Thank's in advance.if you need the excel i will upload it.

Hi all, First post, but long time browser. I have been using browseto over the years with mostly a good outcome, however I have now encountered some strange behaviour. I have a button which onclick changes to a different form. I can make this work fine, however on the onclick before the browseto command I have some vba code to check that...

Does anyone know how to create autonumbers dependent on a chosen catagory? I'll explain the scenario..... I am working on simple a reel database for a post-production company. The required fields are: Client Title/Description

Hi evryone, i am sure you have probably had this questions several times. I am new to Access, so please bear with me. i have data on an excel sheet imported into my access database. and this data needs to be inserted into two tables. The parent table is linked to the Child table with the help of a primary key in a one to many relation. i can...

I will try to explain this to the best I can. Currently, I am creating an asset inventory system. In the system, I have 2 tables (IT Assets and Contacts) and 3 separate forms (AssetEntry-F, AssetChecking-F, and Employee-F). I am in the process of creating the AssetChecking-F form, that will serve the purpose of checking in and checking out...

I'm trying to write VBA to create a button which will go to the relevant line in a linked database for a specific client. First I need to have VBA that IDs when the client name in the report matches that in the linked table. This is what I have so far. DoCmd.OpenForm "Clients with matches Full Report",View:=acFormsDS, ,WhereCondition...

Hi Folks. I have an access application that is using SQL server 2019 for the backend. All of my "queries" work but when the Update and insert statements execute Access will display the append or Update warning but nothing is actually being written or changed in the SQL tables. I believe I need to establish a SQLOLEDB connection string in my...

Hi! I have a splitform where I want to have the button to allow the user to choose and import the file into the table. I have something like this: Private Sub Command287_Click() With Application.FileDialog(msoFileDialogOpen) .Filters.Clear .Filters.Add "Excel Files", "*.xlsx,*.xls" .Filters.Add "Access Databases", "*.accdb" ...

Hi all, Can I pick your brains please? I need to a scan a serial into search box to return it's records of repair into a list box. There will be more than one record against the same serial. I want to be able to select a repair job from the list box to view the full details in the form below. The db is only using 1 table. What would...

My most important client is changing their ERP from Sage to ERP-One+ by Distribution One. The new database is Progress, and they've installed an ODBC for me. I'd like to know if you have any experience with Progress and what quirks or gotchas I might encounter with that connection. I do not, unfortunately, get server access, so I cannot write...

I have pulled Clients, Volunteers and Meetings into tables into Access. I need to make a summary page for each Client and Volunteer. If they are matched then the summary should include the name of the client or volunteer with whom they were matched and the first and last times they met. To do this I made a Left Join between the volunteer table and...

Hi Everyone Im struggling to pass a form value to a public sub sqlstring, when I reference the form directly, it works... Public Sub CalDeleteTopSheet(strCal As String) Dim strSqlDelete As String strSqlDelete = "DELETE " & strCal & ".Summary" & vbCrLf & _ "FROM " & strCal & vbCrLf & _

In the office users often leave my application running when they go for lunch. While they are away the PC will go into standby or suspension, and the network access will be lost, causing a error message when the users return to their machines, not to mention that the backend is usually blocked from edits even though noone is actually using the...

Hello! I have a situation where there is a "Welcome" from(page) when it is first opened and there are buttons (such as Repair, Quotation and New) in the page. I want to make those buttons move to the forms -Repair, Quotation and New- that are under a NavigationControl when those buttons are clicked. Once it's first entered, I can move freely...