Recent content by Firefly

Hey everybody i want to know if theres a way to decrease numbers in a list box after a double click event. Here is a detail of my project. i have the following in a text box called txtAuthorization on a form called frmcharges on the double click event Private Sub...

Okay i have the following in a combo box called cmbzip on a form call frmMember SELECT tblCityStateZip.Zip, tblCityStateZip.City, tblCityStateZip.State FROM tblCityStateZip; In the after update event i have the following Private Sub cmbZip_AfterUpdate() Me.txtCity = Me.cmbZip.Column(1)...

There is no audit trail this is just a sample of a very complex database for personal use. I will try your way but maybe this clearer explanation might help what i'm trying to accomplish. I just designed 2 basic tables might not need the tblbatch Example situation Employees are given batches...

i have 2 tables One called tblmembers MemberID(PK) Batchnumber LastName FirstName Address1 Address2 City State Zip The other called tblBatch BatchID(Auto) Batchnumber(PK) As you can see by the sample database what i want to do is have a user enter a batch number for new records he/she has...

sample database Here is the sample database i'm trying to modify for my own form

i have a table called tblMember which has the following MemberID(PK)(auto) Surname FirstName BatchID(Left Blank Until Report is Printed) I also have a table called tblBatch BatchID(PK)AutoNumber BatchDateTime Basically what the below code does is assign a batch# when ever new records are...

Never Mind Got it to work with your Ideas changed everything around like you said works perfectly just needed to create an append query now i need to review my homwork a little on queries lol.

Ok Got the Left outer join working and will be tinkering around a bit with my other reports.. Will fix to your recommendations. But just for hear sake lets say i Will name tblDeafultpin and change the fileds to TaxID1 and NPI1 so they be different and delete the record where the Insurance is...

As you can see by the attach Not all the Insurances are showing up on the report. If you take a look at the frmProvider and Go To default Pin tab you will see one insurance with a specific set of numbers and you will see another one where the insurance field is blank which will apply these...

Please see attached i have a main form called frmEmployee which is a tab form on the images tab is a sub form I created a browse button when you click on add image command button but cant get the browse button to work. so i can insert picture Any Ideas. Also If possible can I embed a picture...

Please see attached I have a combo box which has Open/Closed. What I want to do is if user selects Open The Green Gif Will appear If the User Selects Closed The Red One will appear. Also is it possible to insert gifs into a txt box or another combo box. Thanks,