Search results
-
A
Command Button
In the properties of the button modify the on click event to DoCmd.Close acForm, "Youf first form name" DoCmd.OpenForm "Your second form name", acNormal -
A
Syntax for referencing a subform
Go to the Modules tab Open a module and paste the following: Function OpenDSView() On Error GoTo OpenDSView_Err DoCmd.OpenForm "Your form name", acFormDS, "", "", , acNormal OpenDSView_Exit: Exit Function OpenDSView_Err: MsgBox Error$ Resume OpenDSView_Exit End Function... -
A
Syntax for referencing a subform
I am sorry Unfortunately you would have to drop the idea of having the main form and the subform. Because the filter is applied only on the main form. May be it would be easier to mimic the datasheet view. Because by placing the buttons on the continuous form everything is working and everything... -
A
Record navigating in the form view question
In your query you need to create another field which will extract the first letter from the Last name field ex. Alph: left(yourfield,1) base a subform on that query link a subform to the option control on the main form. -
A
Error Message: TextBox
Most probably your Regional settings for the date/time in the control panel of your PC are not the same as the field requires ... -
A
Updating Records!
Why at all do you need to subtract anything form the table? You can make your calcs on a form or on the report. Could there be that PO cosist of several items? and delivery comes also in several items? -
A
Dissappearing Froms..!
Go Tools>Options>View Check the Hidden object option You will see all the hidden objects of your dbase. -
A
Some basic questions regarding forms
Well you need to resolve the couple of issues. 1. With your autonumber field 2. Why the field doesn't accept the value of concatenated fields "Format" doesn't mean that you actually parsing this value to a field it is still 123, try to add 10000 It could be that you are trying to create the... -
A
Syntax for referencing a subform
Weird behavior but you still can do what you want. Place a button on the main form Select a "Form operation" for a type of command Select an "Edit form filter" Click "Finish" NOW in the properties of the button modify "on click" event to DoCmd.DoMenuItem acFormBar, acRecordsMenu, 0, 0... -
A
Update a Date/Time field automatically
In the properties of this field set the default value to the =date() -
A
Populating Spreadsheet control in Access
Oh I see ... you want to specify the record source for your form The easiest way of doing it is to use the "Create form using wizard" on the "Forms" tab in access. Launch it and follow the steps. for you information I've also attached the example of my previous reply. Unzip both files to your C:\ -
A
Populating Spreadsheet control in Access
If you are using this control to input or display the data in excell then you need to insert another cotrol ( Microsoft Web-browser object ) instead of your current control and display excell in it. if not then you go to file>get external data>Link tables Select from the "Files of type"... -
A
Performance issues with queries
I am not sure but this is probably depends on where you query is processed ... on the AS/400 or on your PC. If you sending request directly to AS/400 it is processed a looooooot quicker. What are using ? a linked table ? or pathrough query ? -
A
Calander Control W/ Scheduling HELP!
Yes it is possible ... can you post a print screen of your form ? -
A
Have a calendar display entries
See the attached example Although it is used to enter the standard working hours. Select a student and click on any date ... it will change a color, click second time it will change to the next color ... Color indicates how many hours were spent.