Search results

I don't make changes while users are in it. I use a system that kicks users out based on the value in a table which works for 90% of all users. What happens is that if any of the remaining 10% are not at their desks at that moment, then the maintenance can't be done. I feel that if users were in...

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...

The aim is not to design tables while users are working in them; the aims are: 1. Stability: By keeping users from being in tables (especially more than one at a time) I hope to avoid data 'car crashes' and table corruption. 2. To be able to change table design at all: Having users 'Out' of...

I was able to reprogram the onclick of an existing button to an existing function like this: btn2.OnClick = "=Runnit()" where Runnit was a no-return value function in the same form: Private Function Runnit() MsgBox ("It ran.") End Function If you're looking to have more control over...

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...

It's a question. I want to know the official or proper way to finalize the value of a textbox using 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...

That put me on the right track. I wasn't sure where to put your code, so I put it in form_load of the main form, but no dice. I noticed the table with #deleted was clearing up if I clicked in it, which led me to track the run of the code. Form_Load wasn't even running when I opened the 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...

No dice. My main form is unbound to any data and I get "You entered an expression that has an invalid reference to the property Dirty". The textbox itself is also unbound. I just check if the textbox is not blank and if so I use sql to update a field to the value in the box.

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...

Not so, Roku! I put a messagebox in the gotfocus for the combobox to test it. On first entry, or when changing the focus on the form portion away and back then the messagebox appears. If I am in the combobox and go selecting around in the datasheet portion and then click back into the combobox...

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...

Thank you. This is a split form with datasheet and single-form looks on the same screen. My friend had me do this with conditional formatting, so that is how we've solved it. I will try to bear in mind that non-single view forms can misbehave. I had also run into the problem where my label...

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...

Okay! The answer to my problem is that I was using cint() to convert text quantities in an earlier query. When I ran that query I got an 'overflow' error because the new data had quantities over 32000. I converted using clng instead, and the other query stopped giving up. XP

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...