| |
thread by: fslosser |
last post Feb 27 '19 by: fslosser
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.
|
thread by: argel |
last post Feb 28 '19 by: twinnyfo
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...
|
thread by: beginneraccess |
last post Mar 2 '19 by: twinnyfo
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
|
thread by: CD Tom |
last post Mar 4 '19 by: twinnyfo
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...
|
thread by: williamson1979 |
last post Mar 7 '19 by: twinnyfo
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...
|
thread by: aidan24969 |
last post Mar 5 '19 by: twinnyfo
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...
|
thread by: Obakeng1168 |
last post Mar 5 '19 by: twinnyfo
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. ...
|
| |
thread by: gburch |
last post Mar 6 '19 by: gburch
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...
|
thread by: hargrav123 |
last post Mar 6 '19 by: twinnyfo
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...
|
thread by: brikusi |
last post Mar 7 '19 by: twinnyfo
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...
|
thread by: pc13401 |
last post Mar 7 '19 by: Rabbit
getting error above, see query below. Please help.
TRANSFORM Sum(.) AS SumOfAmount
SELECT (.)
FROM ( LEFT JOIN ON . = .);
WHERE (((.Classification) Is Null))
GROUP BY .
PIVOT .;
|
thread by: Abhean |
last post Mar 8 '19 by: Abhean
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...
|
thread by: KarlosMacronius |
last post Mar 11 '19 by: Rabbit
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...
|
thread by: brikusi |
last post Mar 11 '19 by: brikusi
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...
|
thread by: Nancy` |
last post Mar 9 '19 by: twinnyfo
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.
|
| |
thread by: brikusi |
last post Mar 11 '19 by: brikusi
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...
|
thread by: beginneraccess |
last post Mar 11 '19 by: Rabbit
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,...
|
thread by: Albi |
last post Mar 10 '19 by: twinnyfo
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.
|
thread by: BATEN |
last post Mar 10 '19 by: twinnyfo
any body can help me?
how to create ATTENDANCE in oracle forms and it's trigger?
|
thread by: Sage24 |
last post Mar 10 '19 by: twinnyfo
i am absolutely lost
|
thread by: Obakeng1168 |
last post Mar 11 '19 by: twinnyfo
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
|
thread by: imranullashaik |
last post Mar 11 '19 by: twinnyfo
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
|
thread by: CD Tom |
last post Mar 11 '19 by: twinnyfo
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...
|
| |
thread by: ahmetthecool |
last post Mar 11 '19 by: twinnyfo
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?
|
thread by: brikusi |
last post Mar 15 '19 by: twinnyfo
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...
|