Microsoft Access / VBA Forum

I'm receiving the following error: The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time. no one is trying at the same time.

Hello guys! I'm new in Access and as such there are small details that escape me. I'm building a database of equipment composed of its characteristics and mobilizations. I have a form that allows the user to search the equipment by keyword, location, equipment center and status. In a button click search if I intersect the search of the keyword and...

Couldn't find a way to make cascading combo box to disappear/cascading combo box not in use disappear... but now found the answer... If DCount("1", "queTask1") = 0 Then '!! & cboTask.Value = " " Me.cboTask.Visible = False Else Me.cboTask.Visible = True End If

I'm not sure where to look for this problem. I have my access 2007 .accdb application. Now when I try start access 2007 on my main computer it will not open. It tries to open with the Microsoft installer, I answer Yes to allow changes, it then starts the office professional 2007 installation, stops in the middle of the processing bar and then...

Hello, I have a form that has a 3 columns with 10 materials currently, this could grow and the materials used change daily.The first column subtracts inventory, the second simply calculates the percentage of each material and the 3rd adds inventory. What I'd like to do is; Create multiple comboboxes to select the materials used that day...

I have made an access database and need to be able to limit the amount of entries for specific attributes. This is the contents of the table: Student Subject Enrolment (tblStudentSubEnrol) • Student Code (tblStudentDetails) (Relationship) • Subject Code (tblSubjects) (Relationship) • Date of Enrolment I need to be able to limit so there...

I am expected to produce an xml as per the sample EDI claim xml that I have attached. I only managed to achieve it by using several queries as per the database that I am attaching. When I export the date comes with time, I used the format date in the query to change it to date only, but when I put it in the other queries it refuse to export. ...

This is a follow-up to my previous Access issue of synchronizing the scrolling of a datasheet form with a datasheet subform, which works fine. I am using Access 2016 under Windows 10. Because the scrolling solution above is executed by the AfterUpdate() event, it occurred to me that a user may circumvent the solution by starting his/her...

Using Access 2016. Form using unbound controls. After entering data with an attachment, data goes into a table (tblAgenda). The attachment information shows up as a new record of its own in the table versus showing up with the data (record) it was submitted with. Below is my code. Private Sub btnSaveSubmit_Click() Dim rs As DAO.Recordset, db...

I have 2 tables. Once called tblPerson and the other tblMember for a church database, where I am trying to replace the ID field with their name from the tblperson table. I have the following Dlookup in the query: Shepherd: Dlookup("","","='"&&"'") When I run the query with this DLookup no errors, no values. Field is just blank. Sample of...

getting error above, see query below. Please help. TRANSFORM Sum(.) AS SumOfAmount SELECT (.) FROM ( LEFT JOIN ON . = .); WHERE (((.Classification) Is Null)) GROUP BY . PIVOT .;

Hello everyone, thanks in advance. I am working on a medical inventory Dbase where I need to separate a QR code into the needed info. I did the seperation in query Example GTIN: Mid(,3,Len()-34) So far all good. Now I need to connect another Table to the calculated fields and running into problems at doing so. So I am hoping that I can...

Hello, I'm new to access and I realise that this may be an incredibly basic question, but... I am trying to populate fields of one table from another table. I have a number of hand written forms to digitise by putting them onto a database. We have a register lists and a detailed information sheet for each item listed. Some info from the...

Writing a query for a database where in the query it's displaying the profile of a family. I want the dependents to appear in 1 field concatenated and separated by commas. So if there is more than 1 dependent in the family it appears in query in 1 field listed. New to Access so i was trying to get 1 piece to work at a time. what I have so...

I have used access 2007 for years. all of a suddee, the menu bar which has run command (!) is missing. please help me get that back. thanks.

I need help building a simple Access Attendance table for me to query and build reports from. This table will only need: PersonID Date Comments However I don't want to manually enter the date each time. I want to be able to create a form whereby the personID is already listed and i just simply mark for that day a checkbox and leave...

Is there a way to triple check that the data is consistent between the three tables and show if there are any discrepancies in any of the three tables? Each table is not completely the same but they all have an EmployeeID, amount, datepaid, and CID column. When I did with two tables I thought I had the SQL as: SELECT tbMaster.EmployeeID,...

I have a test and one of the questions can be the upper one, i just have to write the formula for it in the Design View as >L<???? for the First leter capitalised but i need the oposite one the last letter Capitalised, hope that you unterstood.

any body can help me? how to create ATTENDANCE in oracle forms and it's trigger?

i am absolutely lost

Option Compare Database Private Sub Form_Load() For i = 0 To CurrentDb.TableDefs.Count - 1 If InStr(CurrentDb.TableDefs(i).Name, "MSys") = 0 Then cmbTable.AddItem (CurrentDb.TableDefs(i).Name) End If Next End Sub

i am developing an inventry control database, how to update stock when we purchase and sell items, when we purchase new items it should be added to stock, similarly when we sell an item it should be detected from stock. i have written a sql update query which updates only one record, how to update all records

This has just started on some of my customers computers. I call outlook from within my app to send out emails. My program is on customers computers is compiled .accdr, I getting calls from some of my customers that they are getting an error "function not available". When I do the check references I find that the Outlook object library OLB is...

Hi I need to fill automatically the control source of text box depend on any excel. For example, I have an Excel file named "values" and When I import this file Access automatically fill the control source of a text box "bounded first column". Can anyone help me?

Please help, I have a database whereby i am tracking attendance on a daily basis, however i may need to update the table more than once in the day as people enter the service later after attendance have already been captured. my current setup does not work. i have detailed it below. Please help me to understand how I can update the table...