Search results

Yea so i have 330 records when i run the sqlstatement and refresh i have 331 records.

So this is my code it works but instead of appending to the table it adds a new form that is exactly the same as the previous form . do you have any ideas of why this happens. DoCmd.RunSQL "INSERT INTO [tblNotesCurrentMeds](Medications, [Date], MRN) VALUES ( [Current Meds].[Medications] ...

This code works, it adds the fields i need to my tables but on my form they are not updating. I tried a docmd.requery but access says it cant find my subform!!!! Private Sub Discontinue_AfterUpdate() DoCmd.RunSQL "INSERT INTO [tblNotesCurrentMeds] (Medications, [Date], MRN) VALUES...

This is my code does is the syntax correct? IF it is, its not compiling. DoCmd.RunSQL "INSERT INTO qryDiscontinue (Medications, Date)" VALUES & _ (Forms![qryCurrentmeds]![Medications],Forms![qryCurrentmeds]![Date])"

Can somebody please help me understand this code Private Sub CheckBoxName_AfterUpdate() Dim strSQL As String strSQL = "INSERT INTO TableB (FieldB1, FieldB2, FieldB3) " & _ "SELECT " & Me.Field1 & " As Expr1, " & Me.Field2 & _ " As Expr2, " & Me.Field3 &...

So instead of using my tables i create two queries. And I have added an sql to insert the data but it gives me a error "syntax error in the insert statement" here are some screenshots Private Sub Discontinue_Click() Dim SQL As String If Discontinue = -1 Then SQL = "insert into...

Im trying to copy one criteria from one table to another. Basically I have two tables on one form. When i check the yes/no button up my statement should come up. this is my db take a look tblNotesCurrentMeds.Medications this was my attempt at telling the db where to store the information.

Im trying to write a dlookup statement when my Discontinue yes/no check box is checked it will copy one field from one table and put it in another table. the error i am getting is Test cant not find the field '|' referred in your expression Private Sub Discontinue_AfterUpdate() If...

Im going to attach my db I dont know another way to explain it

I have a table (Current Meds) nested on my form that has a yes/no box (discontinue) clicked in every data entry. When i click on the yes/no box (discontinue) I want to copy data from that row and add it to a different nested table (tblNotesCurrentMeds) on that same form. I cant get it to...

Currently I have a database that has multilevel user access meaning that I have a (Admin, User, Other) user access option? All three users will have access to the same backend data but all three will have a different frontend form. Now i want to use Sql server to backup my backend table and...

OOOOK i feel stupid thank you

I want to write an if or case statement that opens my form depending on the criteria. i have tried both neither work. If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) Then lngMyEmpID = Me.cboEmployee.Value Select Case...

I dont understand when i call my funcution "re" im telling it what combobox i want = re(combo26) and my results goes in to an unbound list box thats link to my query table

Yes I have i Have two combo box (BU Name, Device Type) in both of their after update section I call my requery funcution(Function Re).

I have and query and a form. ON the form i have two combo boxes. I have a function that i call on update of the combo boxes it requerys the data Function Re(T As String) On Error GoTo Re_Err DoCmd.Requery "List105" Re_Exit: Exit Function Re_Err: MsgBox Error$ Resume...

Never mind i fixed it thank you it was and right join SELECT [Copy Of Asset to BU2].BU_Name, [Copy Of Asset to BU2].Year, [Copy Of Asset to BU2].Expr1002 AS Device, [Copy Of Asset to BU2].AssetNumber, [Copy Of Asset to BU2].[Date Ordered], [Copy Of Asset to BU2].DeviceType, [Copy Of Asset to...

Ok the excel spread shows the table i want. it shows All data i need but if i try to add my "AH_Assinged_AssetNumber" column it will give me the "table 2" results. I need to be able to add "AH_Assinged_AssetNumber" and if there are no users in it should give me the message "No Users".

I need it to show all the Bu with Assets no matter what it. with criteria or not

Currently Im working on an query that suppose to output alot of data. The query shows most of BU but it Bu's criteria is null then its i would output all my data example. Bu | DAte | Initials | Blah AS 01/23/12 ds sd DS...