Recent content by PureCoffee

Craig, Do you know the code? acRefresh or something?? Thanks -Steve

Recordset is set to "Dynaset" but I am not sure what all this is. Sorry. Steve

I have created a database with forms etc. When I enter data and then go to a linked form and then go back, the previous page's data is not there. I had to create a command button on the forms to "Refresh" form data. Any idea as to why I would have to do this? The command button seems...

Never had this happen before but... I have a database that when, I enter data and then go to the next form, the data I just entered is gone. I had to create commande buttons to "Refresh" the form data. Does anyone know why this happens? It was my understanding that Access was...

Fergman, Do you mean that you want a "Form" that will pop-up so a new employee's information can be added to the dbase? Steve

Just an idea. As an option, you could throw everything into an Excel Spread, convert it into an Access Table and then build some nice looking forms based on a query or two. Make it look nice, create a Switchboard etc. When I say, throw it into Excel I am not saying in a careless manner of...

Joe, Sorry! You did but it still didn't work. Not your fault I assure you! I felt I was taking to much of your time and so thought I would try the same question under "Forms Forum". I finally got it working to open the Exact record (Name of Company in the field) and not just the...

Jeff, I tried this but get a "Syntax" error. Most of the time it has to do with the program stating something along the lines of 'end of statement'. At any rate the "DoCmd.Open" portion works fine. As a new Access User/Developer etc. what books would you recommend so I can...

Jeff, IT WORKED!! Now, is there a way to code more so that once I "double-click" and the "Company" form opens that the other(Contact) is closed down automatically? Thank you. Steve

Jeff, I did that but get a Syntax error. Any other ideas? Here is what I typed: Private Sub CompanyID_DblClick(Cancel As Integer) DoCmd.OpenForm "Companies", , , "CompanyName='"& CompanyID.Text&"'" End Sub

I am trying to write a piece of Code so that when I double click on the Name of a Company on one form it will open that Record set in the "Companies" form. The Form "Contacts" has a Combo Box which would select the Company the contact works for. This is set up through a...

I have tried the "Rules" wizard and it did not work. I have tried several ways within rules and it did not work. How can I automatically forward incoming messages to lets say HotMail? Any ideas? Thanks

Joe, Thanks but I guess I didn't explain myself very well. What I wanted to do was open the Record or in this case, the Company "Selected" as opposed to ALL company records or the Companies Form. Seems I must do some more "code" or something. As an example looking at the db...

Thanks Joe. It is on its way. Far from being finished and I am a fairly new Access User. I am trying hard to learn all I can. Steve

Sorry Joe, There must be something I am doing wrong. It still opens up the "First" company I have listed in the dbase. Hmm. Any other ideas or do you think I just have something wrong in the way the dbase is setup? SF