Search results

Thanks SQL_Hell 1. If I copy from the SQL Server backend to the Access 2010 frontend, will I still be getting the full benefit of having SQL Server as the backend? All users have access to the same overall data but usually only update records that are relevant to their work, and there isn't...

I currently have an Access 2003 database split between a front and back end. When a user wants to edit a particular record, they click a button and the record is copied from the backend table to a temporary table on the front end, which they can edit. And on the backend, one of the fields on...

Thanks Uncle Gizmo Looks like I was missing a trick after all!

Hello I have a table that includes the following fields: - TaskCategory - DueDate There are 15 different types of TaskCategory (e.g. Accounts, Payroll, etc) and DueDate may be any date. I want to summarise this information into a grid with: - DueDateBands along the top (e.g. Overdue...

Thanks for your help with this Gina. I think that I'm stuck with the main form / subform situation. I have a tab control with a different subform on each of the 3 tabs and am using the tab control as a way of widening my main form i.e. each of the 3 subforms link to the same records, but just...

Thanks for that Gina I've tried your suggestion for linking the subform with the unbound combo box on my main form. Nothing shows up when the form is first opened but as soon as I select an item from the combo box the subform populates, which is how I think it is intended to work. However, I...

Hi Gina 1. My understanding is that you can create a query in VBA, e.g. "SELECT Records FROM Table WHERE Condition", or you can create a query in Access, i.e. by double clicking on 'Create query in Design View'. The query created using Design View can be viewed in 'SQL view' and this SQL...

Hi Gina I'm using Access 2003. Thanks for the links. Actually, I think that the reason I set the subforms to be without a RecordSource was after reading the following section from the granite website that you have suggested http://www.granite.ab.ca/access/performanceforms.htm I'll...

I've set the subforms to be without a RecordSource, and then define the RecordSource to be the query called 'WorkOutstandingQuery' when the main form is opened. I've read that doing this makes opening forms quicker than if the RecordSource is already set before the form is opened. Overall, my...

Thanks for looking at this GinaWhipp! I'm using Access 2003. Within the WHERE clause of my query is a string called ClientNameSelected. There is a combo box on my main form related to the client name. If this combo box is left blank, then ClientNameSelected = "1 = 1". If a particular client...

Hello I have a form that contains a tab control. On each tab is a subform whose recordsource is a query. When combo boxes on the main form are updated the query is updated and the subform updates. The problem that I have is that it takes a long time to refresh the subform and I'm sure there...

Thanks plog. Sounds like a good approach.

Hello Any advice on the best approach to take regarding the following issue would be appreciated. I have a table which stores information about the progress of various tasks. There is a record for each task, and a field for each time the progress is updated (Prog1, Prog2, ..., Prog50)...

Hello again Bob Sorry to post again before allowing you to respond to my post below, but I've had another thought. I've got to thinking about switching to using a saved query as the recordsource for my form, and I think that it will have some advantages. Currently I'm calculating some...

Thanks for coming back to me again, Bob. Regarding changing the recordsource in code vs changing the recordsource property - I have combo boxes on the form, which when changed alter the results on the form by changing the recordsource (as below). Is there a way to do this directly in the...

Thank you for your reply Bob I thought that my original structure was looking directly at the table, but it seems that I may have already been doing what you're suggesting, though without realising it. In my VBA code for the when the form opens or is updated the following code is included...

Hello I'm hoping for some advice about whether I should be using a table or query to hold the underlying data for a form in my database. Any thoughts much appreciated. My database is split between a BE and FE. There is a form in the FE which has a table in the BE as its recordsource. When...

Thanks David I think splitting at an early stage is going to be the way forward for my future databases. speedball

I went on an Excel VBA training course once when I had very little knowledge of the subject and didn't find it very helpful. Then a few years later, still with very limited knowledge of VBA, I bought the Dummies guide to Excel VBA and found it far more practical and useful. I've not been on...

Thanks for the responses guys I was intending to split the database just before releasing it to other users, but in light of datAdrenaline's suggestion I'll split it next time I work on it. Thanks again speedball