Search results

I am trying to lock a from using the forms lock on the condition that a check box is checked. But it I run a vba procedure that updates certain fields from a lookup table that fills the fields it seems to break the lock . Is there any way aroung this? Thanks in advance for any replys

summary by critereia in a report I have a report that has a status control box for hardware . I need to get the Summary Count of a a condition of the hardware for the ( Up ) or other conditions . How can I go about this ? Can I use a formula attached to the count funtion in the control box ...

Private Sub Command39_Click() Dim db As Database Dim qdf As QueryDef Dim prm As Parameter Dim rst As Recordset Set db = CurrentDb() prm.Value = Me![txtbox0] Set qdf = db.QueryDefs("qryProbeCardtouchdowncount") Set rst = db.OpenRecordset("qryProbeCardtouchdowncount") MsgBox ("Duh " & rst!ID) End...

:confused: I have a working query that is the result of two joined querys . When I Open a recordset it looks like I would need to put in both querys in order to make things work . How would this be coded?

I notice that the FindLast method is missing when I type in type in the dot after rst but if I try to type in DAO before I type in recordset to select DAO.recordset that is also missing , DAO that is as a choice. How do you call up these functions or is it possible? Do you have to call up the...

I need to find the last record based on a field that is being updated with a value from a combo box . I'm trying to do this by opening a recordset based on the table that the form is based on . as a Snapshop recordset and using the FindLast command . Also Once it finds the record I'm not sure...

Is there any way to add a column/field to and existing table then import data into it? Or must you always import an entire record. I realize it is possibe to export and modify in excel then reimport it.

I can import data to a table with no problems from excel if there is no relationships to the table. The thing is I want one of the tables for Site Location to be changeable from a form to reflect transfer of a piece of equipment to another site . If I use the lookup wizard an make the field...

I have been fumbling with setting up user Security and have the following questions on multiuser security. When I set my self up as Admin and remove the default Admin login I still don't seem to have absoulute authority on existing databases. I think its because the owner is still Admin ,but as...

How many recordsets can you have open at once? I wish to make a report by opening a a recordset and use a list to look to the last instance of an item in the recordset then move it to a temporary table or recordset where I can run a report on it. I think I can open a a snapshot recordset and...