dantebothermy
Last Activity: Sep 3 '09, 01:57 PM
Joined: Nov 1 '08
Location:
-
I'd prefer that each person can have her own arrangement, but I'd be happy to just be able to change the master copy with different arrangements. -
Saving rearranged columns in a datasheet form
My users and I use Access 2003.
We've got a subform in datasheet format. How do I, how do my users save the layout after re-arranging columns?
Thanks -
Thank you ADezii,
this has been puzzling me (and the tech support folks here) for months.
DanteLeave a comment:
-
Renaming Table Changes Query or Script
Hi,
I'm using Access 2003.
Sometimes, when I have a table used in a query, if I rename the table it Access also renames the table in the query. It's also happened in VB scripts.
It doesn't do it consistently, but it scares me.
Does anyone have any advice how I might be able to avoid this?
Dante -
My mistake; I meant reports.
Thanks againLeave a comment:
-
Thank you NeoPa. You helped me find the one piece of the puzzle that I was missing. I'd been looking for the events associated with the controls, or at the form level, but not at the detail section level. Now I see the "on Format" event.
Thanks again.
DanteLeave a comment:
-
NeoPa,
Thanks for the offer, but it's not necessary; I have a solution that works. But if you're willing to give me 3 or 4 minutes, (and no more) I'd like to understand where to put the code you suggest -- do I go into code builder and build a sub called control_format( ...); if so, is it attached to the control or to the form definition?
Thanks,
DanteLeave a comment:
-
NeoPa,
I admit I'm baffled. (I'm only a programmer by circumstance, not by training.) Note, I'm using Access 2003.
1: What's the "Format event". Is that the format tab in the properties of the form?
2: I can't put that code in dialog box for Is Visible -- it limits me to Yes and No
Can you explain? Thanks.Leave a comment:
-
I found a different answer
Thanks.
Actually, I found a different answer: I changed the label to a text box and set the control source to iif(isnull([related control]),null,"Label Title"). Then I set the Can Shrink properties for the label and the related to control to Yes.Leave a comment:
-
Access Report: Hiding field and Label when field is null
Hi all:
On Access 2003: I have a tabular form with labels next to the associated fields. I'd like them both to dissappear when the associated field is null. ("Can Shrink" will do this for the field, but the label is still there, so the report does not shrink.)
Any ideas how I can make the label shrink too?
Thanks, -
dantebothermy started a topic Using combo box in form to select sub-group of records or to select all recordsin AccessUsing combo box in form to select sub-group of records or to select all records
Hi all,
I have a form with a subform. On the form is a combo box with three choices "current", "former" and "all". I'd like to use that combo box to set the data source for the subform based on the status field referred to in the subform.
I've tried to set the data source to a query based on that value -- it works for "current" and "former", but I can't figure out how... -
Tabbing between subforms
I have a form with four subforms on it.
Somehow or other, when I tab all the way through the list of tab stops on subform 1, it moves to subform 2. But the same thing doesn't work between any of the other subforms.
But I never inserted any code to make this work! Magic!
My question is how do I set up a tab order so that users can tab from one subform to another? -
I'm sorry to hear that. But thanksLeave a comment:
-
Query Function? Max of options
I'm looking for a function that is similar to one in excel:
=max([field1],[field2])
I know I can write it using an iif statement, but I'm looking for an easier approach. Any ideas?
Thanks,
Dante -
ADezil,
thanks for the reply.
The record source is a table, not a query. Would the equivalent be to refresh the data?Leave a comment:
-
Using Access to Edit SQL Table: Form with Multiple tabs
I have an Access form with multiple tabs; the underlying table is in SQL Server.
The problem comes up when I edit and save a record on tab 1, then go to tab 2 to to edit a different field of the same record. I get the following error message:
The data has been changedAnother user has edited this record and saved the changes before you attempted to save your changes. Re-Edit the record.
If you click OK in the... -
Data Mask for EMail Addressess
I thought this was an easy question, but I can't find an answer anywhere.
How do I set up a data mask in Access for email addresses?
There are two parts I can't figure: First how to set up part of a mask to accept unlimited characters. Second, what character to use that will accept any character EXCEPT a space.
Please help. Thanks.
Dante -
How can I use Access to edit SQL tables?
(This thread should supercede my most recent question.)
I have tables on a SQL Server database; the tables are linked (as linked tables) to an Access database.
Access will not let me edit the data or add new records on the remote tables.
Anyone have advice?
Thanks,
Dante -
Thanks, DBrother, but this is a case of lasers in the hands of cavemen. I'm still progressing from Neanderthal to Cro Magnon.
I'll try to decipher your (very generous) advice, but I'm afraid it will all be far over my head. (Also, I'm using Access 2003; from a quick search of the web, I don't think that CurrentProject. Connection is available for that version.)
thanks again,
DanteLeave a comment:
-
Replies to Linq and DBrother
Linq
1: The quotes are not in the code
2: The crash is an error message: "Run-Time Error 2105. You can't go to the specified record.
DBrother
Can you give me any insight about how to find the CurrentProject. Connection? It sounds like exactly what I'm looking for.
DanteLeave a comment:
No activity results to display
Leave a comment: