Search results

I once made a split database with tables in the back end and read-only queries in the front end. I was hoping that the backend would only be in use when people ran the queries and otherwise would not be in use. That is, I would be able to compact and repair, redesign tables, write back-end VBA...

I have a split database made in Access 2007. Each user gets their own copy of the frontend from a script. I wanted to be able to edit the design view of the backend tables even if people were using the database so I made all the forms use snapshot source and only allowed data updates through VBA...

In Access 2007, I'm using labels as buttons because they can be made pretty. Since labels can't have focus, the focus is not shifted from whatever textbox users are in on button press. The value in that textbox is not considered updated when the macro runs, and things get messy from there. I...

I have a form with a subform. The subform is a datasheet for my main form (like a split form, but as a subform to avoid naughty split form problems). The subform has a Form_Current which I use to clear and repopulate main form fields when different records are selected. One of the main form...

I have a form with two subforms. One subform is a datasheet that pulls data from a temp table. During the other subforms Form_Current, the temp table is emptied (DoCmd.RunSQL "Delete from tblAddRefs"), reloaded with data relevent to the current record, and requeried...

I'm using a label as a button so it looks nicer, but if I press it without officially exiting the last text field I was in, then that text field doesn't update, so the vba believes it's blank or whatever it was. I could manually setfocus to a couple different fields or have a teeny field thats...

I have a split form that was not made by wizard. On the form part I have a combobox that is unbound to the form data set. The combobox has a query row source that is based on the current row selected. I want the combobox to have an up-to-date result based on which row is selected. If I set...

I'm trying to change a textbox color on my form based on whether a box is checked in the record. The display is off, though the color I want is always displayed for the record I was just at: What I want: checked? Color chk pink chk pink chk pink not white chk pink not white not white not...

I have a set of over 1 million records that I am designing queries for. To maintain sanity, I made a selective deletion query that leaves 1 out of every 500 rows left standing and deletes the rest and I test the queries on that. I've come to a point where I need to run queries on the full data...

I run a crosstab query. I sort on the sum column. Works. I check to design view to make the sort permanant. Try to run. 'Cannot have order by on aggregate clause'. Crud. Go back to datasheet view. Sheet is not sorted. Sort on the sum column. 'Cannot use the crosstab of a sum column as a...

But should it? We have links to the company database (db2 series 1), as well as a back end access database on the network. We have a query for fields on the company database that looks like a spider web on the query design screen, and if we restrict those all to one record, it runs in under a...

I have a query that is a table joined with another query of our company database. The query of our company database is actually a 'final query' joined together from 5 queries of the company database. There are a number of left() and trim() functions used in these queries. The query that is...

We made a nifty page that can construct a query for users by selecting checkboxes and entering info into fields on a form. Then VBA code builds it into an sql statement, assigns it to the .sql property of our universal query, and opens the query. It works nicely until they try to sort on...