Search results for query: *

Great Thread multiple stars for multiple people! Quick Question... I have a form with one subform. I was ondering if there was a way to email as an attatchment just the current record of the parent form with all linked child records as well. I am using outlook, and was using this code to...

Thanks Paul, Works Star! Neo

Thanks for the quick response Happy Turkey Day! Possibly the problem is I am not communicating the difficulties I am having clearly. What I am looking for is a way to have a true alphanumeric sequence. The format trick works on the form but not in the actual data in the table. Also the two...

Alec, Nice of you to notice that the values of both will always be equal and thats a handy little trick....You get a star! Thanks, It will help on my database too. Neo

I have a button set up on the bottom of my database with the following code to send the form frmSIR via email. Private Sub Command64_Click() On Error GoTo Err_Command64_Click Dim stDocName As String stDocName = "frmSIR" DoCmd.SendObject acForm, stDocName...

I have been told to stay away from them as well, however I still think they will be the best for my use, The only problem I am having is I want to make an alphanumeric autonumber (format AB1234) Where AB is dependant upon a combo box in my form. When I select the job site from the drop down box...

Michael, I do not have enough programming experience to properly modify the code listed in your FAQ. Also the FAQ does not cover this particular instance where I need the two letters within the Case Number to be dependant upon which post location is selected in the dropdown combobox (i.e...

Thank you both for the quick responses, If the recordset was locked properly, would the code provided above be feasible? Neo

Thank you ken you just cleared up a whole lot of questions for me. Have a star! A Very Grateful Neowynds

Looking at the code with my limited knowledge it looks like it would work for me, however I am a bit of a newbie, so where exactly would it go? In an event and if so which one? Thanks for the Quick response Neowynds

Hello all, I am done with my Security Incident Report database except for one thing. I need it to auto generate a case number for each file as they are entered in. The format for the number needs to be NM1234. The two text characters will be dependant upon which location they choose from a drop...

If you are using the company intranet is it possible for her to make a data access page and link it to a website so that the other person can use the database without ever opening access. Im just a technical user but I think the concept might work, I would ask some of the more experienced people...

OK, Not sure if anyone is still monitoring this thread or not, but I have set up my database to be exclusive so that only one person at a time may have the database open. And these are the steps I took to try to get an autogenerated CaseNumber Table = SIR 1. Table - Field named CaseNumber...

Sorry it took so long to respond Ken I decided to take my first 2 days off in over a month. This was the exact problem. Thanks again Neo

Thank you I think I will go with opening in exclusive mode. Just on the offchance. Thanks for the advice. Neowynds the REALIST. I am not optimistic nor pessimistic but a delightful blend of both. Wich sometimes causes a quarrel in my mind. You dont wanna see me when THAT happens. TRUST ME...

I see your point, however the nature of this particular database is that the user will not even have it open unless there is a security incident (i.e. fire, theft, etc.) The chances of three officers all filling out incident reports on three things that happened simultaneously is slim to none...

What do you mean declared? The combo box row source is a query that contains LocationID,LocationName,and Address. I made sure all three were still in there when I opened the database in 97 because I had run into the problem of not having them all in my query before. If you mean did I have them...

Maurie, Where would that go and what would the code be? I am looking at making a numbering system for case numbers and need something similar to an invoice number. Also there is very little chance of two users entering records simultaneously on my database since there are only three authorized...

Thanks for the Quick response, No no error. It is a blank box, almost as if it is not registering the third column in my query the combo box is based off of. If I switch the column number to 1 I get the LocationName. But when I switch it to 2 I dont get the address like I did in 2000. Its very...

There is a good example of this in the main switchboard of Northwind sample database.