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 ...

if you remember the name put it back You have to put it back with the same name as before I think . Otherwise you have to reinstall access. This security system is a pain the but. Always keep a backup of the mdw file .

I only have a single parameter , from a single field on an open form that I'm trying to input to the query as the parameter. The Query will return a single record. I would think there would have to be a path to the Query definition using its name in one of the recordset statements or qurery def...

Thanks for your reply but this didn't solve the problem Private Sub Command39_Click() Dim db As Database Dim qdf As QueryDef Dim prm As Parameter Dim rst As Recordset Dim Temp As String Set db = CurrentDb() Temp = Me.txtbox0 MsgBox ("The Current Probe Card No is" & Temp) Set qdf =...

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...

Thanks for your replys and help. The query is based on the same table that the form is based on . The query was first used to genrate a report of the status of hardware where the most recent date of entry for each item is displayed . I modified query with a criteria such that the field for...

Thanks for your reply I know how to get the the SQL statements and first I thought I had to move the whole def inside the code . So since this compromizes two SQL statements from joined Querys how do I get two joined querys work inside a recordset . Then I realized I shouldn't have to move the...

: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?

First of All thank you for your reply I realize the record sets can be resorted which means the last record won't always be the one with the highest date. I usually protect against this by locking out the ability of the user to add anything but a new record which should always be the highest...

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...

FindLast Method ? I guess this doesn't exist anymore in Access 2002. Is there any substitute ?

I tried this now I'm getting a message that it Can't Find the FindLast Method?

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...

Thanks for your help . I managed to get the stuff in I wanted but I still have some stuff to learn about the best ways to do this. Also it seems that if the rest of the Excel sheet isn't clean it doesn't like it. My solution was to move only the stuff I wanted into a separte sheet with that...

The trouble is if you append only a column it wants to put the column in a fresh set of records. That is if you want to add 5 records in a column to a new field in the first 5 records( 1 to 5 ) instead the column appears to generate 5 more records( 6 to 10 ) with just that column in it

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...

This is a little confusing. When you create a workgroup with the workgroup manager to my limited knowledge it modifys the System.mdw file. If you give the new.mdw file a different name you have two mdw files. How do you resolve this? I am having trouble understanding this because of the parsing...

But when you add a new workgroup you are effectivly changing System.mdw are you not?