Recent content by shurgs

I have a Query Subform of the Progress Table, which is related to the Young Person table I am editing with this code. Could be the problem? There's not really any way I can get rid of that subform though, so if that is the problem then I guess there's nothing I can do about it...

Reopening an old thread here. This code works, but occassionally I get this error message when I use the dropdown box to select the new Outcome. "The data has been changed. Another used edited this record and saved the changes before you attempted to save your changes. Re-edit the record." Now...

Hi Wayne. I was unaware you could do that! Very helpful indeed, thanks! -Shurgs

Hey, I'm stuck (again) So, I want to look up a record in my table "youngperson" using the current value of a combobox and then update the "Outcome" field with some text. This is what I'm trying: Dim db As DAO.Database Dim rs As DAO.Recordset Dim i As Integer...

I've programmed in many languages in my time and used many front-ends and I can honestly say I've never in my life come accross something that fails so hard. For everything you make Access finds someway to break two other, completely unrelated things. It's like trying to wade through a pool of...

Turns out I found some duff information about IDENT_CURRENT on the Internet. Turns out what I was looking for was: rs("progid") = DLookup("max(pid)", "progress") I officially feel silly. Thanks for your help, though. shurgs out *Csshkk*

Hi, thanks for the reply. I have a button that adds a new record in the "progress" table and a tickbox that states whether or not that new record is a referral or not. If the checkbox is ticked I need a new record in the "referral" table that's related to the progress record by "progid" in...

Hi there. Trying to add a new record, while filling some of the fields in with information from the current record in another table: Set db = CurrentDb Set rs = db.OpenRecordset("referral") rs.AddNew rs("agencyid") = 1 rs("progid") = db.Execute("SELECT pid FROM progress WHERE pid =...

Thank you!

How do I clear a textbox with a date in it with a tickbox's OnClick event? Thanks, -shurgs <3

Nevermind. I didn't bind the form properly :P

Woah. The third option has dissapeared. It only has "I want the combobox to look up the value..." and "I will type the values that I want". How do I get it back?

Thanks for the reply, bro! This helped me greatly.

Hi there, First off, I'm a bit of a "newbie" to access forms and their controls and I can't program in VBA, so forgive me if I'm missing something obvious with this question. However, I have knowledge of programming and macros, so good explanations won't be entirely lost on me. I'm making a...