Search results

Thanks Big John Is there any way to fix this ?

This is a bit difficult to explain, but I'll try... I have 2 tables, lutbl_Role and tbl_Staff. The Staff table has a field "Role" which references the Role table at form level. I have a 3rd table, tbl_Project (presented on a form; frm_Project) which has a sub form; frm_Resources which...

I have 2 tables which populate 2 different forms tbl_Work_Request which populates frm_Work_Request and tbl_Project which popuates frm_Project I have a list box on the Work Request form which when double-clicked, takes the value that was double-clicked and passes it to the code below...

Im running Access 2007 and Id like to use Outlook 2007 to update a table in my database. Im guessing I would need to create an Oulook form and somehow link Access with Outlook. But how do I do this without too much code ?

Hi I have a query that takes the value in a form control as its criteria... [Forms]![frm_Work_Request]![txt_WR_ID] A control on the main form (a list box) is populated by the query. This works fine. When I go to the next record on the main form, I want the query to run again (I dont need...

maybe you could post your database here for us to look at

Your post is a bit unclear, but if you are asking how to increment a value in a textbox by one each time a button is clicked, then on the click event of your button you need something like... YourTextBox.Value = YourTextBox.Value + 1

you need to configure an SMS Gateway. There are a number of providers out there. Here's one Ive used in the past. http://aql.com/

I agree with Bob. Im a Business Analyst and giving an accurate estimate is like trying to nail jelly to a wall... What might seem a small project to the Customer can quickly grow into a complex project that requires some complicated code and clever queries (which I think you referred to as ?)...

Could you explain where I would use this Currentdb.Execute command ? The query itself is only running over 200 records and only returns 3 fields. Its very lightweight.

No, you misunderstand. I have tested this idea offline before I go back to IT with the NEW solution as I wasnt happy with the INITIAL solution that created the table within their database. Creating the table in MY database and forcing them to Open the Query on close is a much better solution...

OK - I have sorted it. Here's what I did... I created a Make Table query in the Source Database that creates a table in MY Database. I added a DoCmd.OpenQuery command to the Form.Close event that opens the Make Table Query. As long as the user of the source database always clicks Yes to...

The Light table will NEVER have to be updated - just read from. I had another idea. Maybe I can add some code that forces a Make Table (making a table in MY database) when the Source Table is saved. They can then just click OK to delete the old table and I will just make sure I compact my...

I cant link straight to it as there is data in there that they dont want me (or anyone else) to see, like Salary etc. I will only be able to READ from the tbl_Employee_Light. I actually need to link to more than one table, namely tbl_Employee tbl_Role tbl_Department

Hi, I have a database which needs to link to a table in another Access Databse (tbl_Employees) which I have no control over. The other Access Database is my company's HR Database so some data in there is confidential. However, the IT Department have created a Make Table Query for me and the...

Ironically I created a database similar to what youre trying to do. Id say you might have made a couple of small errors in your structure, one being, a vendor might have more than one property. Well, thats what I found when I was creating mine. If you upload it I can check it over if you like. Al

just seen your next post. Just put your criteria on the same line. Remember to save your criteria before you run it again

OK, you should really create the following tables... tbl_Role_Position (for the position) tbl_Department ...and then look up these tables from ComboBoxes on your form. For a quick answer I havent created these tables for you, just the employee table and a simple query. This query basically...

Im not sure that makes sense. Last Name, Position and Department are the same ? As in... LastName = Department = Position LastName = Smith Position = Smith Department = Smith I obviously know you mean something else, but what do you really mean ? Al

Sorry but it must be me being stupid. The example at the link you sent me doesnt seem to work. Shoul I expect the Service Combo to change when the Category Combo changes? It only changes if you force a refresh.