Search results for query: *

Is there any way I can allow a user to change a default value without going into design view in runtime? I would like to allow users to be able to change the default value (table level default)to a default value of their entry. Thanks!

I need to create a left side margin on a report for the FIRST page of a report to accomodate pre-printed stationary. Is there any way to do this? Thank you!

I have a problem with custom toolbars. It seems that some of my users do not see the custom toolbars in their runtime distribution of my db. Does anyone have a good grasp of how to make custom toolbars more reliable...so they actually show up on all users distibutions? Thanks!

I want to return a value if 2 different check boxes are checked (-1) Something like: IIf([rtxtchk]=-1) And IIf([ltxtchk]=-1),[bilattxt],"") What is wrong with this expression? (sorry, I have been working too many hours !!)

I have a backend table I can not update (at present, due the complexity involved). Is there a way I can make Form defaults over-ride the table defaults? Thanks!

I am having trouble adding a button to reset unbound text fields to a value of "0". (the form is a calculator function and I want to be able to allow users to reset the fields to 0 with a button) Any help would be great!

How can I get formating of percentage with no decimal places in a concatenated field? Right now I get xx.00% from: Format([rightpercentnorm],"Percent") Thanks!

I would like to create a button on a form which will copy the contents of an unbound field to the clipboard. I have been unsuccessful in my attempts. Any ideas?

I am trying to use MS Slider Control on an unbound field. I have set the properties for the control but it does not update the value when used. Is the a trick to this? I can find no documentation anywhere on the slider control. Thanks!

Is there a way to create a button which will select the contents of an unbound memo field and copy it to the clipboard? Thanks!

On an unbound text field I am trying to define a catagory based on the value of another field. for example, if the value of field [step7totpri]is between 7 and 24, then its catagory is "1, Mild". I can not get this expression to work: =IIf([step7totpri]>=7 And <=24,"1, Mild"," ") &...

I would like to automatically move to a specified field on the same form when a chkbox is checked. Any ideas?

I have an unbound field which I want to display the largest value found in several other unbound fields. ie. FieldD = which value is larger, FeildA, FieldB or FieldC Any ideas?

I need to format percent number in a concatenated field: "Mr Smith was measured as having 45% of normal ..." I need to format the number to a percent. Now I get "0.450000". Also, I remember that I was having difficulty with Access Runtime and concatenated default fields which contained special...

I have tested storing and running a backend file on a USB Flash RAM Drive. This alwows the user to allows have their Current Data with them. Everything works fine. Initial connection and table re-linking is very slow (about 1 to 2 minutes!) Once the initial re-link is done however the start time...

I am trying to get a Listbox to open a diferent Form to the record selected by the listbox. Here is the code I have to select the record on the Afterupdate: Private Sub List6_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone...

I have a Listbox on form1 and I would like it to Open form2 to the record clicked on in the listbox. Here is the code which I got to work when I crreated the listbox on Form2: Private Sub List618_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs =...

I am trying to enter a form feild default value which contains plain text and table values. I can't seem to get it right. Something like this: ="It appearing that the applicant.."&[FORMS]![main]![lastname] I need the default to enter "It appearing that the applicant... Jones" Any help?

I have a split Access db which my users run in Access Runtime. On installation I have the backend located in the same directory as the front-end. I would like to allow users to install on a peer to peer or network and open the program with the same backend file. (share the data over the...

I have tried to work this out: I would like a feild on my form to move to a secondary feild automatically IF the user inputs over a certain number of characters. This is needed as the size of the form and report are too small to accomodate a large amount of text. If the user is entering text, I...