Search results

I've spent the last hour searching for threads I thought were related and patched together some code, which I know very little of. Here's what I want. I have a form with only 3 fields, one of which is a combobox ("Type") with 3 options ("Charge", "Payment/Adjustment", "Balance Transfer") I...

No I haven't. And now I do see the BeforeInsert event. I was looking on individual field properties and not the form properties. But I'm confused how the form properties will allow me to copy in 3 of the fields but not the others. I assumed I needed to put it in the field's events?

On reading over my notes, I realized I had the code in the BeforeUpdate event, and not the BeforeInsert as suggested above. However I do not have a BeforeInsert event field available to me. Is that due to the version of Access? I have a hard time believing that but I'm not sure what else it...

Ok it took me this long to get the code changed and give it a try, but I can't get it to work. I have this in the Before Update event... Private Sub PatientName_BeforeUpdate(Cancel As Integer) If Not Me.NewRecord Then Exit Sub If Not (IsNull(Me![PatientName].Tag) Or Me![PatientName].Tag = "")...

I've only used a subform once and my brain has gone absolutely blank today so please forgive me for the following stupid question(s). I haven't set up the database yet, I'm still drawing it out on paper to see how best to set it up. For every record we will need an Account#, Name, and Type...

Funny, I was just coming on here to search for a similar question. Another route I thought of going was having ONE subform, but having different fields visible/invisible depending on the selection made in a combo box on the main form.

I saw that same post when I searched, sorry! Since I didn't insert the code I wasn't exactly sure when or how it was doing what I wanted and didn't want to mess it up. Do I remove the code from the AfterUpdate and event and add it to the BeforeInsert? Or remove from both AfterUpdate and...

Why certainly. :) Forgive me if I cut paste more/less than needed, as I don't really know vb well at all. After Update: Private Sub Account_AfterUpdate() Me![Account].Tag = Me![Account].Value End Sub Private Sub Account_Enter() If Not Me.NewRecord Then Exit Sub If Not...

I have a very simple database set up for a department to notify me of charge corrections I need to make in our main system. The form is set up where each record is a line, and a new record just goes on the next row instead of a new page. (Tabular view, I believe) I have some simple code set...

OK, but I don't think I'll have any temporary tables. This is a pretty straightforward, uncomplicated database. I'm just unsure if I need to bother with splitting it, and if I do, why the frontend can't remain on the network server with the backend.

I guess I'm not sure what you mean by temporary tables...

Everything I've read about splitting a database has talked about leaving the backend on the network server and putting the frontend on individual PC's. Is there any reason the frontend couldn't stay right where it is on the network server, and put a shortcut on the desktop? A second question...

Well I'm off to get the "IDIOT" tatoo on my forehead. The control source on the form I was trying to print was pointing to the wrong query. :rolleyes: Sorry about that.

That's very good to know, Pat, thank you. When I did that and chose the field Account from the list, it didn't put it in brackets. So I ended up with Me.Account Does the brackets matter? Other than that, does my code appear correct? I have another form that does the exact same...

Wait, I do remember making a change here. The line DoCmd.OpenReport "OPLabels", , , "[Account] = " & Me![Account] read: ....[OPAccount] = " & Me![OPAccount] But that was a typo on my part. There was never a field named OPAccount, so I changed it to just read Account. Did I inadvertantly...

I am going crazy here. I had this db just about ready and was making some slight changes (in appearance only) before rolling it out. I had a user log on and try to use it to see if I was missing anything. Before, on the form OPRegistration, you clicked a button that saved and then printed the...

:D I very well may use this word for word!! LOL Thank you!

I have a db set up that we use as a temporary patient registration system when our main system is down for whatever reason. On several forms there are command buttons that will print a sheet of labels for either the current patient or, in one case, will prompt for the account number of the...

In searching on this subject there has to be roughly a billion questions on this same problem. :eek: I APOLOGIZE!! I bet you're all smacking your foreheads as you see the title to these posts. None were exactly the same thing I was trying to do and I couldn't quite figure it out. But it's...

I found this bit of code when searching DoCmd.OpenReport "ReportNameHere", , ,"[ID] = " & Me![ID] But that won't help me if I need to save the record first, correct?