Microsoft Access / VBA Forum

I have a subform of all the customers for the day (limited info). I want to open the specific record on the parent form by clicking an action button, on a specific record, on the subform. I have the following Event Procedure for the action button. When I run the procedure, I get a Run Time Error (3021), No Current Record. What am I doing...

First, yes, the title of this thread doesn't make sense, so if anyone can come up with a better one, I'm open to it. Here is the situation: I have two Tables. Table1 - This is a list of words in the Greek New Testament, sequential, indexed, listing the word forms, root form, translation and a dictionary entry. This dicitonary entry is the...

Our IT staff will no longer support Microsoft Access. We were working in Access 2013 and now we have been upgraded to Microsoft Access 2016 until our company moves to Accela for our database needs. Surprisingly, our Access 2013 database still works in Access 2016 except when we try to run the following module. Can anyone help me re-write the...

I export my table to XML using the export form from access but doesnt look like it should because is looks different from the .xsd file especificatins I must follow. How do I tell access to use this especific .xsd file when exporting my data to the XML file??

I have a cross tab query with Date as a row heading and a series of Names as column headings. The Value for each Date/Name intersection can either be -1, 0 or 1. For example: Date, Name1, Name2, Name3, Name4 1/1/2000, -1, -1, 0, 1 1/2/2000, 1, 1, 0, 0I would like to have a column ("Members") that counts the non-zero values for each row. ...

I have created a data base with 3 tables. The first table has only 2 records and each record is linked to many in table 2. I have used a form sub form to eneter table 2 data without problems. I just select the name of the record in table 1, and enter everything else in table two. In table two I have used a lookup to table one for the name in...

Here is the code that keeps erroring out. If (IsNull(DLookup("EmployeeID", "tbl_EmployeeData", "EmployeeID = '" & Me.txtEmployeeID.Value & "' And password = '" & Me.txtPassword.Value & "'"))) Then MsgBox "Invalid UserName or Password!" Else 'Verifying the User Security UserLevel = DLookup("User Level",...

I have created a unbound text box (txtSearch) and a Button to use with the text box for searching all records on a form. The field on the form that I am using for the search is labeled Full_Name. When I try to search for a first name of any user in the Full_Name field nothing happens and I get no error. Here is my code. Private Sub...

Hi all, i would appreciate your professional help. i am create a restaurant POS. i have buttons on a form, where each buttons adds an item (Burger, Pizza...) into order table and displays it in a continues form. my question is how to add a topping to Pizza for example. let assume a customer order pizza i have the button that adds pizza but if the...

Hi, I'm very new to Access and having great difficultly trying to sync 2 combo boxes. I have been using The MS Access help for this issue. I have one Combo box titled sboPackageNumber and and another titled sboPackageDescription. My Table the data is taken from is called Sheet1. The columns on the table are Package Number and Package...

I have created a class module that should allow me to sort records in a form based on selections made by the user. In this case, I have the user double click the label to sort by the corresponding field. Everything works great except that it doesn't sort anything. Part of what it does is change the label captions to include up or down arrows to...

I have an Access form with action buttons one of which is a duplicate record button. When activated, the duplicated record has one of the yes/no fields toggled on. It is not toggled on in the originating record; just the duplicated record. Any idea of why it is happening and how to correct or stop it? Any help will be greatly appreciated. ...

Hi, I want to pull values from a text box during the button on-click event in a form and store it as a new make table function. Or While clicking the button, I want to use the values in the text box to create a new table and show as output. Any help would be appreciated.

I have an access database that is split into a front end and a back end database. I have around 50 make table queries that make a table in the back end database. Currently I have the Another Database radio button checked Under filename I have referenced a Path and the back end database name. A user may request the back end database to be...

My reports have a =date() and =time() in the headings to show when the report was run. However on some computer when the report is run those fields show up with the #Name? I'm sure it has something to do with a reference being missing but which one? Thanks

hi, i am new to this website. But i was looking for answers to solve a problem which I have with access. would you be able to help me please? I have a query named "qry_BO_NA_Search". I also have a form which it's job is to search by different criteria from the query. In the form, I want a button to export the search results only...

I have created a database (New to Access) to keep track of the club members. BUT I want to record the start dates and finish dates of the members fees. I want to be able to look back and see what members paid fees and from and to dates. Is this possible and anybody have an idea how I could do it. Thanks Ger

I have a table containing an airline's complete flight listings for a month. Using Group By I have made another table containing all the flight numbers with unique properties other than date departing (eg flight number 2322 appears in the table twice, departing at 09:00 and at 09:10 on another occasion). Most flights leave at the exact same time...

I need to generate a serial number by selecting drop down menu and adding data in text box using Form. Drop down Menu : It consist of table what would have individual ID. EX : Table : Product1; ID = 23. Product2; ID=24 and so on. Text box data in a form : It could be any value "Numeric" Random. Serial Number EX:

Hello, I am trying to requery a control on a main form from an AfterUpdate event of a control on a subform and then return back to the record and control at the subform. Instead i am returned to the first record of the subform. When i debug, it seems correct, the record i want does show correct at the findfirst statement. but at the form the...

Found this code off a google search to remove the close "X" from the title bar. But when I go to compile it throws an error. Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them PtrSafe attribute. Private Const GWL_EXSTYLE = (-20) Private Const...

Hello, I have an access database with 50 tables. I am looking to export all tables into a folder on my computer. The issue I'm having is the data in access has carriage returns or line breaks on some lines. When I open the exported CSVs as a text file, some lines are broken up. What code am I missing to clean the data during the exporting...

If I change the .Display to .Send I get Error '-2147221238 (8004010A) The item has been moved or deleted. Its sending the email without the attachment. If I have it as .Display it works perfect, other than having to click the send button. Also if I remove the .Display all together its the same as if it was .Send So my guess is its sending...

Private Sub Form_Close() If Me..Value = "Purchased" Then Dim strEMail As String Dim oOutlook As Object Dim oMail As Object Dim strAddr As String Dim MyDB As DAO.Database Dim rstEMail As DAO.Recordset

hello, I'm trying to get my list box database to open up another form that contains more information on the selected record. I can get it to open the form just fine, but it always opens o the first record, rather than the one I have selected. My error message is: Run-time error '3075': Syntax error (mising operator) in query expression...