Search results
-
V
Accessing Access tables programmatically in Access 2000
Dare to call yourselve a Access Noob?? NO WAY... Sorry don't know the answer.- VBITS
- Post #2
- Forum: Modules & VBA
-
V
a user opt in of field on a form
With my code the 'apply' button comes available when everything is filled in, you need to make a button which is not enabled, and rename it to any desired name, and fill that in in stead of cmdButton -
V
Need help with Recordset data.
Dim rstRecordset as Recordset (Make sure ADO is in the reference's list) Set rstRecordset = CurrentDb.Openrecordset("SELECT Field1, Field2 (ETC) FROM Table1 (OPTIONAL: WHERE Field1=X);",dbOpenDynaset) Refer to the fields in the recordset as: rstRecordset!Field1 (AFTER MOVING TO THE FIRST...- VBITS
- Post #2
- Forum: Modules & VBA
-
V
Lookup without code
Sorry to be the messenger, but it cannot neetly without VBA-Coding... If you want to learn more about VBA coding there are some ways to learn. As VBA is quite simple (Certainly to English native speakers), you could install the NorthWind database from the Office CD, it contains lots of usefull... -
V
a user opt in of field on a form
Create a private function in the form as follows: Sorry to use other variables (it's a copy paste :)) Private Function IsFilled() as Boolean Isfilled=True If isnull(me.txtDate) then IsFilled = False If isnull(me.txtName) then IsFilled = False If isnull(me.txtContact) then IsFilled = False... -
V
on open set focus
Is your first form allready a popup? Elseway you need to close the first form in order to get the seccond one opened properly -
V
Problem in editing records on a network
Don't know completely sure, but I think autoincrease does take care of this... If not, create and SAVE a record to the DB on the moment a user begins editing record 3... As soon the user finished editing, save the other fields into the record (UPDATE). This way you will keep your data... -
V
Performance in a Network
By the way, Indexes where the first thing I checked, but still the bloody FE pulls like 300K's for a simple form having 4 fields :( -
V
Performance in a Network
Well, I also thought off ways to syncro... As the machines which use the FE are all high memory machines (at least 512 MB), I thought off the following, exept I come to a point where I cannot get further. Can anyone help me out? - When opening the FE a Mod Declares X Recordsets (Where X is... -
V
Refer to subform
I suppose your Parent form is like a grand total (Bill), and your (Child) Subform is like a rule on the bill, and you would like to get the sum of rules displayed in your Parent window... What I would do is: Create a query which calculates the sum, and refer your form to the same options as you... -
V
Performance in a Network
I have a database which has got a front-end and a backend, both on other computers in a network. When opening a form (and requesting the backend for data) I noticed like 300K was received from the server for a 8x3 table (integers and text only). This is probably caused by Access which isn't...