Recent content by fearmichaele

well I questioned that as well when i had taken over this project. the answer I was given is currently our institution uses numbers to tag equipment but are exploring using alphanumeric to tagging so I left it alone.

ilsadog well I did consider that option, but the user may only have a tag number to look up. if the tag number is in the database, then the user can pull up the equipment information such as where its located, who it is assigned to, purchase order number and cost for the equipment, etc. if...

wait!! MajP that was it. i didn't see the single quote you placed at first. this did the trick and i thank you very much.!!!!! :D i figured it was something that simple. it works like a charm. Thanks again.

yes it is a number stored as text. i did add the ampersand and the quotes at the end like you typed and still throws the same error.

the table design, TAG is a short text.

i have read other post about this error and tried adapting their fixes to fix my error without success. i have a form which the user enters a number in a text box in order to search for that number in a query. if the number is not found in the query I want a message box to pop up saying...

i figured out the issue. so the query builder used for this form was borrowed from the Employee form. thanks to MajP and theDBguy. I looked at the data in the query and it was sorted ascending by employee name. i change it to sort ascending by locationPK. now the form is working again. i...

during the stepthrough the criteria = "[LocationPK] =" & Me.cboSearchByOffice.Value showed the correct information to search for. when it got to the .findfirst criteria line it automatically went to the .nomatch line. i placed a msgbox ([locationpk] & " " & cboSearchByOffice) in the .nomatch...

Also, this form is accessable via multiple venues. 1. I have an employee form that I can search up employees and then open the location form at the location where the employee is assigned. this works good. 2. I also have another form where the user can look up an item tag number and then...

thanks theDBguy. I have not changed any structure of the table. I have stepped through the process. I even added a msgbox telling me what the LocationPK is and after .findfirst locationPK was not changed to the cboSearchByOffice value. LocationPK remains at the last location looked at. so...

Hello fellow VBA users. i have a dilemma. I have a relational database that is SQL tables on the back end and Access 2016 on the front end. This is an equipment database that I have been tasked with updating functionality. This problem was not a problem until yesterday. i have a form that...

Ridders, in Sql Server 2016 the table is named TblIntakePatient but in Access it is named TblPatient. the VBA statement wanted me to use TblPatient (Access name) instead of TblIntakePatient (SQL name). That is what i did to fix my error. And yes after I did that, I did realize that I needed...

[incompletedoc] is a BIT field in my [TBLintakepatient] table. i have figured out what I was doing wrong. in my statement I was using the SQL table name. In access the linked table has a slightly different name. In access the table is called TblPatient which is linked to...

thank you for the quick response. so i adjusted my code to read I am still getting VBA Error 3144 Syntax error in UPDATE Statement.

I have a front end Access Form that is linked to a SQL Table. one the form when the user presses a button i want to ensure that the field named IncompleteDoc is not null but has a 1 in it. In SQL i would use the following query statement to accomplish this. update...