Search results

This line causes the errror: rs.FindFirst "[CharityName] = '" & Me.CharityName & "'" but not always..... I'm wondering if I have a corrupt form....?

If I use what you suggested, I get a Type MisMatch error... and I'm not sure how your's is different from mine...? I have: Dim frm As Form Set frm = subfrmCharityDetail.Form Set rs = frm.RecordsetClone and you have: Set rs = Me.subfrmCharityDetail.Form.RecordsetClone...

I am executing from my main form. The field, "CharityName" exists on the main form.

I am using Access 2010 and for the life of me can't see why I am getting this error message. I am using the following to filter a subform from my main form: Dim rs As DAO.Recordset Dim frm As Form Set frm = subfrmCharityDetail.Form Set rs = frm.RecordsetClone...

Aha, I got it! Me!subfrmEquipmentAdd.Form.Image46.Picture = "Z:\Shared\Location\Machine\No Picture.jpg"

Sorry, no good. I get an error: "Object doesn't support this property or method"

I am hoping someone can point me in the right direction as I have had no luck searching for an answer to this.... I am using Access 2010 and I have a subform that contains a picture control. The image in the picture control is added to the form as follows: Dim a a =...

I'm sorry, I'm not sure what you mean exactly? As a parameter? Okay, yes, this works now! Thank you! PARAMETERS Forms!frmAttendanceTracking!ShifttDate DateTime; INSERT INTO Attendance ( EmployeeNo, AbsenceDate, AbsenceReason, Comments, GroupID ) SELECT EmployeeInfo.EmployeeNo...

I am hoping someone can help me out here.... I am trying to write an append query to track employee attendance. I have a table with the EmployeeInfo and another table where I am tracking Attendance records by date. I tried and was successful with this query: INSERT INTO Attendance (...

Thank you for that link. I will give it a try....just one thing, I don't want the users to get the duplicate index Error message - do you think the combination of my code and the unique composite index for the date and shift fields that all will be well? Or should I include some error trapping...

Yes, I went to the table and found 5 records Yes, I have a primary key on that table I'm sorry, but I do not know what you mean by: "a composite unique index on the combination of Shift and ShiftDate" No, there are no other means to add records to this table other than the bound form I created

Hello, I need some advice / critique on some code I have written that opens a form. I wrote it so that if there is a current record (i.e. same date and shift) then to go to that record. However, if there is no record, then go to a new record. It seemed to be working fine for the past two...

That's it! Thank you.... staring at this too long.

Hello all! I am working in Access 2010 and I am trying to create a query that will determine if the value in a specific field has changed when comparing two tables. I have a main table in the database and a temporary table that is created when data is imported from another source. I...

Actually, for the last 3 years there has only ever been one front end and it never crashed when emailing the SNP attachment in Access 2003. I knew what the compatibility issue was, but didn't have the time to focus on making the changes to the database until recently.

Unfortunately, I can't..... even though I said there is only 3 or 4 users in there at a time, I have over 200 users set up to access this database. Should I rejoin it into one (i.e. no front end / back end split)? I split it out originally when it was still an Access 2003 database because...

Yes, the database is split and yes there is one front end in a shared folder. There are almost 5000 records in the main table and over 12,000 in the related table.

There are two of us in the database right now.... sometimes there is only one, sometimes 3 or 4. The report is returning one record with 34 fields from one table and up to 4 records in a related table with 4 fields.

I get a pop-up message that states: Microsoft Access has stopped working Windows is collecting more information about the problem. this might take several minutes.... I see no pattern in the way it crashes.... the email size when sent is 67KB I can send the same report 4 times in a...

Hello! I need some direction / advice. I inherited an Access 2003 database from someone who left my company many years ago. Three years ago we moved from Office 2003 to Office 2010 and have been slowly moving our databases from MDB to ACCDB. This is one of the last databases that I have...