Search results

With all the possible chances of corruption I choose to split my databases into a Front End and Back End. Does your company have a terminal server?

Thanks JDdraw. There really isn't spaces in the field names. I guess I just typed them that way on here for some reason. I am actually ending this thread now since I ended up figuring it out on my own. Again I appreciate you getting back to me!

I have 2 tables that I wish to get information out of, but I am unsure how to set up my query. I hope one of you can assist me. Intake Intake ID Date Of Intake(Date/Time) Caseworker(Text) Risk Assessments Intake ID Substantiation Risk Level(Text) Substantiation Risk Complete(Yes/No) 3 Month...

Hello - Instead of using OutputTo, try using TransferText. I think I was having this problem a while back and resolved it with the TransferText method. expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

Ya I could see the frustration in not getting a response, but luckily I'm a patient person :)

That was exactly my problem.... I just created a new module and my variable there. I really appreciate all the help. I actually learned some important stuff today thanks to you. Have a good rest of the day my friend.

My only issue now is that gintresult is returning no value. I stepped through the process and i do see that its doing what it needs to be doing in the DuplicateNames form process...but its not returning the value to the ParticipantInfo form. Maybe I'm not declaring my variable correctly or...

I understand what you are talking about nschroeder, but am not sure how to pass my parameters yet. I was thinking about having a boolean value for each button (iSave, iNo, iCancel, iList) and passing them byVal to my main form. Not sure if this is the correct way of doing it, but I think I'm on...

Thank you for the reply - correct me if I'm wrong though, isn't that only saving on the "DuplicateNames" form and not my "ParticipantInfo" form? I'm wanting the DuplicateNames form to act as a Messagebox for the ParticipantInfo Form. I'm not at the office right now so I can't really try out...

Hello everyone! I have created a form named "DuplicateName", which I would like to use instead of a messageBox. This form will be ran from the results of a BeforeUpdate event of a form called "ParticipantInfo". I would like the buttons of the DuplicateName form to perform the following actions...

I knew it was something to do with that IF statement! I just ran and tested it and it worked like a champ. Thank you!! My next step is to display all users with that name, their DOB, and their SS#, and Address. You may be asking why a user just doesn't do a search by SS# within my DB. Well...

Hi everyone - I have a form right now which has a First name and Last Name fields (PFirstName and PLastName). I just want to be able to determine if a name possibly exists in one of my tables. The following code that I have is not working yet. Not sure what I am missing. I have 3880...

BJF - I think I had this same problem happen to me one time too. This should fix your problem (but I might be reading it wrong). Private Sub cboItems_GotFocus() With cboItems .Dropdown End With End Sub I hope that is the simple fix you need.

I have a database that automates reports in PDF format to specific folders on a shared drive. If formated correctly with a generic font (arial, times new roman, etc...) you can get the file down to a really small size (10-15kb) also this post may be helpful to you...

@spikepl, Thank you for letting me know that. Its amazing how much of a difference that made in the file size. I chose Arial and it shrunk from 183kb to 24kb. Thank you for letting me know this :)

Good morning everyone - I have written a procedure in VBA that grabs information that a user selects in a combobox and then generates a PDF file. You can either view this file or at the click of a button it will automatically send to the correct users folder located on a local shared drive...

Not sure if this would be of any help but maybe you should read a bit more on this subject. I don't know enough to help you with the sql you seek, but check the bottom portion of this link out. http://www.techonthenet.com/sql/max.php Also why not use the autonumber? I'm no pro either, but...

What type of field is it if I may ask? It sounds like a transparency issue with one of the labels. Have you tried changing the Back Style property to Normal?

I found this example. Not sure if it will help. http://access.mvps.org/access/forms/frm0007.htm

Thanks Bob! I was just thinking about SQL and the WHERE statement. Not sure why I didn't try this haha.