| Thread | Last Post | Replies |
|
| Additional Help with a query | 29 Apr 2008 18:58 GMT | 5 |
I have recently asked this question here about how to create a query when I don't know which field I need to query until the user makes a selection on my switchboard. I am still having great difficulty with a solution. The concept here is as follows. The user needs to know which ...
|
| Error using OWC with Access 2003 on Vista | 29 Apr 2008 17:39 GMT | 2 |
I have inserted on a form an OWC11 chart, did some little coding, added the reference to OWC11.DLL and compiled. Now as soon as the form is opened an error is issued "The expression On Open you entered as the event property setting produced
|
| Append Query Error -Key violation | 29 Apr 2008 16:41 GMT | 3 |
I need some help to figure out this problem. I want to populate a table, let's say [PCR_Run_Details] with records from [PCR_Run_DetailsClone] (I cloned the table to simplify this testing) There are both used as subforms of frmPCR_Run.
|
| Conditional Formating Issue | 29 Apr 2008 14:15 GMT | 2 |
I have a report with 3 fields. fldPriority, fldContractName, fldAmt (control source priority, ContractName and Amount respectivly) I applied conditional formatting to all three: [Priority] <= 5. All is
|
| Going to wrong record | 29 Apr 2008 12:50 GMT | 2 |
Hi I have the following code in my form Incident Data Entry: Dim Docname As String Dim LinkCriteria As String Me.Form.AllowEdits = True
|
| Moving to Last record and display | 29 Apr 2008 07:46 GMT | 1 |
Hi All, I'm using the form to both display data and data entry. When displaying data, I have swich off the AllowAddition property of the form, and turning it back on for data entry. The detailed records are displayed on the Details
|
| Cascading Combo Query | 29 Apr 2008 07:07 GMT | 1 |
I have a combobox that will pull an order number cbo.OrderNumber then I have a cascading box cbo.OrderLines that lists all the lines on the order. I am not sure how I can I pull the item number for the OrderNumber and the OrderLine.
|
| Macro Message | 29 Apr 2008 07:03 GMT | 1 |
I apparently have commited a sin in a Microsoft Access database. I created a macro (Macro1) and then deleted it. Now everytime I open a form I get the message [database name] "can't find the macro 'Macro1. The macro (or its macro group) doesn't exist, or the macro is new but
|
| Search Problem | 29 Apr 2008 06:13 GMT | 1 |
I used the wizard to create a Search Button . The problem with the button is that it doesn't consistently work. Sometimes, I get "You can't use Find or Replace now." when I open the database form. I have the form data entry property set to NO. The data mode is set to Add.
|
| Use the 2nd form to insert data to uneditable 1st form | 29 Apr 2008 06:07 GMT | 1 |
I have a form that bound to a query.And I have two empty txtboxes in that form.I want the user can see the data but can't editing it.So I set the properties Allow edit to No.But in some reason I want the user to entering
|
| After Event Update issue | 29 Apr 2008 02:54 GMT | 1 |
I am trying to pull a value from another field namely another column. In the After Event update. Me.cboOrderNumber.column(6) = Me.txtVendor I am having issues with the column(6)
|
| in a report | 28 Apr 2008 23:56 GMT | 3 |
I have a report, I have a footer that has =[WIMS_SUB_VEND], I want this to count the number of wim_subs is it =count[WIMS_SUB_VEND]? Ryan
|
| Deleting and Re-Creating a folder | 28 Apr 2008 23:52 GMT | 19 |
I am trying to use the DeleteFolder Method to delete a folder, called, say, "C:\FolderName", followed by CreateFolder to recreate it. I have used Help to determine the appropriate syntax but seem to be having no success in getting the compiler to accept my efforts. Would ...
|
| Query field question | 28 Apr 2008 22:34 GMT | 5 |
I have two query fields one which divides into the other. i.e. fieldA divided by fieldB = fieldC, easy enough, except that instead of getting an answer such as (fieldA) 2752/ (fieldB) 2800 = (fieldC) . 9828 it gives me .90 it rounds
|
| Form design to maintain many-to-many relationship | 28 Apr 2008 22:26 GMT | 4 |
I have two tables and a linking table and I need to provide a way for the users to maintain these relationships. tblKW: KWID and KWDesc tblDT: DTID and DTDesc
|