Recent content by mvanella

Bumping to see if anyone with a Access 2010 can test out the forms for me. Still wracking my brain on this one.

I am considering moving my access DB and front-end application from Access to C# with MySQL or Microsoft SQL Server. Has anyone done this? Was it difficult? Is it worth it? Do you have any advice for the move? I really like the Free and Open Source advantage of MySQL over SQL server, any...

Access won't let me convert it to 2000 because it uses so many of the newer features. Even trashing the navigation form won't satisfy the requirements. "These features include attachments, multi-valued fields, offline data, data macros, calculated columns, links to unsupported external files...

Here's a front and back end with (I believe) all proprietary information removed and a few dummy entries. Full functionality will only work in Access 2010, and you will also have to re-link the tables when you extract it. The frmWhiteboardLAN is the main navigation form, if you click on the...

Yes the tables are in the backend and linked to this front end app. I have full permissions for the table and can add new records via the table itself. I can make a demo version with dummy data and attach it if that helps, maybe there's something going on somewhere else. The tables in the...

JHB, the box has a text value of "(New)". The form's recordsource is that of tblRMALabor. I use the form for two different actions on records from the same table. The current click event in question launches the form to a new record, for data entry. Private Sub cmdNewLaborEntry_Click()...

Thanks for all the help guys. I am not sure what is/was going on but when I opened the DB today it is working fine. Hopefully the problem is gone for good, since my code uses the same syntax as your example, Rainlover.

I think I may have found the problem but I wont be able to fully test it until tomorrow morning. It's a subform of a subform. Now I opened up the middle form by itself, with the subform on it, and it seems to be working. However, when it's used in its intended context of a subform of a subform...

Rainlover, I'm using Access 2010, it defaults to macros when I make the command button using the wizard. Also the only thing remotely close to what I am doing that was offered by the wizard was "delete record" but that essentially just calls the DeleteRecord method after some checks and error...

It opens the form with the ID textbox as "(New)" and the rest of the textboxes are blank. I can put in information, but it wont commit the changes.

Recordsource is "tblRMALabor" Recordset Type: Dynaset Data Entry: Yes Allow Additions: Yes Allow Deletions: No Allow Edits: Yes Allow Filters: Yes Record Locks: No Locks

I think you may be misunderstanding. I didn't select a column. I was saying that no matter which edit button I click, and it can be ANY edit button in the entire column, it always edits the first row. So it SHOULD be that the edit button in the 3rd column edits the 3rd row, correct? But it...

So then how do I make sure I am referencing only a specific row? I can click on any edit link in the entire column and it will always edit the first row. It's defaulting to the first row. That's not what I want.

One problem I just found. If there are multiple entries in the datasheet, no matter which edit I click on, when I retrieve the txtID.Value for that row it defaults to retrieving the first entry on the datasheet. Is there an index I need to specify here?

That worked great. Thank you.