Search results for query: *

Ok, so I know this isn't the right way to do things, but I want to do it anyway...lol. It seems like it should be easy but I can't figure out how to make it work. I want to create a button that duplicates the current record, deletes the data from the DateofVisit and Notes fields and then...

Hi guys, I have a database that has several reports that need to be exported to Excel on a regular basis. I understand that you can write code to make this happen automatically for all of the reports at once, and even retain formatting. I would like the reports to save to a desktop folder...

You rock my world! That worked without a hitch. Thank you so much for your help!

Hi All, I have a form. The source of the form is a query which prompts the user to enter a date. When the date is entered, all applicable records are returned. Simple stuff. So, I have a "delete" command button on my form. It works fine. The problem is, if say, the user wanted to delete a...

I will definitely read up on normalization and the usage of keys. I got my form to automatically refresh by just using the Refresh.Me code after the code I posted above. But knowing how normalization and keys work is critical, I know, so I will study some and try to make my db better. Thanks for...

Yes, I don't use it for anything but it is there. In case you can't tell, this is the blind leading the blind over here. I don't know that much about Access... just more than the people who want this db.

Yes, I understand that the colunms start at 0. The fields are auto-filling appropriately, it is just that I have to refresh the form to make them show up. For instance, the combo box is on "LastName" So I would choose a doctor and maybe LastName, FirstName and Address with show up. But in order...

MaxieMax - I get a runtime error when I try to add that to the code using my form name. Duane - I have a linked Excel file that this database is the user interface for. I have a long list of doctors, that repeatedly need to be entered each time they come to our facility. I have a table that...

I don't have much in the way of coding skills, so hang in there with me... I have a form. I have a combo box in that form with a number of fields. The problem is, when I select something from the drop down only some of the fields update in the form. I either have to refresh manually, or leave...

Same as before. The very first line... Private Sub LastNameComboBox_AfterUpdate()

Hi Duane, Yes, I did attempt to compile. I get the same error message.

Any, the other boxes are fields from my Tracy_Lab spreadsheet, not labels, and all bound to the Tracy_Lab table.

Well, I am a pretty basic Access user. What happened is that one of the gals here at work was having to update 2 Excel spreadsheets and a Word document with identical data. I told her I MIGHT be able to help simplify and now I am in way over my head. And of course, no one in my whole company has...

My database is posted above, but the record source for my form is a linked table titled Tracy_Lab. The combo box is pulling from another table titled DrList which gives a drop down showing almost all of the other fields on the page. I am trying to write my code to automatically update the other...

Randy, Column 0 is the last name field which stays in the combo box when the appropriate doctor is selected.

I know how annoying it must be to help the newbies, but like my original post said, I really don't know anything about coding. The codes that I have been able to compile thus far have been by piecing together material I have found online. I did change my Combo Box Name. The code now reads...

Ok, please forgive me. I know very little about coding, but this same code works perfectly in another db I am using. I am trying to update several fields in a form based on the selection of a combo box, in this case Combo53. I set up the code and ran it and get an error stating "Compile Error...

Thanks! Still getting the error but I will repost in a different location!

Ok, please forgive me. I know very little about coding, but this same code works perfectly in another db I am using. I am trying to update several fields in a form based on the selection of a combo box, in this case Combo53. I set up the code and ran it and get an error stating "Compile Error...

Ok, I am confused. What I think you just said is that I can build each record for a day into the text string in the email? Rep: Joe Smith Date:06/01/10 CadType:Shoulder Rep: Joe Smith Date:06/01/10 CadType:Knee Rep: Jim Brown Date:06/05/10 CadType:Ankle/Foot Rep: Jim Brown...