Search results

I would imagine (not tested though) that your final database could reside on the "Thumbdrive" but Access Runtime would need to be installed on the actual PC. You could store the installation files on the thumbdrive, but you would need to activate the installation before using the database. The...

Definately no need to duplicate data. Your initial post seems to have been what you are wanting anyway. However, if you have multiple columns in your combo box for selection purposes (as most purposes do), you can reference the other columns using: =ComboBoxName.Column(1) etc Note...

Move your code to the "On Current" section on your main form. This will "fire" when the first record receives focus, and when subsequent records receive focus. It will also fire when the form is refreshed or requeried. Brad.

Strip off the rest of the database, then zip and post the form. No need to include the media files, I will re-link to something at my end. I will have a look at your setup and test it on earlier media player versions. Brad.

Attach the following code to a command button: Me.MediaPlayerName.filename = Me.TextBoxName You will need the full address of the file. With the media players "AuotStart" property set to yes, your movie will start. HTH Brad.

Use: DoCmd.OpenForm "SingleContactInformation", , , "[RecordID]=" & Me![RecordID] (Obviously you will need to change the RecordID to the field name of your Contacts ID Number) Brad

Vass, I use AccXP and it is possible to have the Ctrl+P print option on a custom toolbar (and thus I imagine it would work in Acc2000 also). View / Toolbars / Customize Then add the "File" Menu from "Built in Menus" Expand the new "File" menu, and then drag the "Print Ctrl+P" option to your...

Try using the After Update event of your "Date In" field to specify your remark date. ie: After Update: me.[Re-mark Date] = [Date In] + 21 Note: Avoid using embedded spaces and special characters in field names. These will cause headaches in may Access operations.

Aww, I was so looking forward to your explanation Vass Looks like I will have to re-read Pat's. ;)

No problem. However, we do expect to hear what grade "we" got on your project. ;) Good Luck Brad.

Bazz, It sounds to me that you are writing to only one side of the inner join in your query. ie: You have an innerjoin between two tables (Only include rows were the joined fields from both tables are equal) Your query is writing to one half of the joined relationship (one of the tables...

I am using AccXP and was able to use the replace statement inside the update query without issue. Thanks harra, that could become handy.

Use an update query. The design grid should include your "Temp Table" and your "Other Table" Create an inner join between the relevant fields (ID numbers?) This will display only records common to both tables. Set your Yes/No field in the "other table" to update to True (or false?) Brad

Your criteria line in the query will be interpreting your date as text that is not date qualified. You will need to include the date # qualifier either end of your date. eg: Me.FullDate.Value = "BETWEEN #" & Me.StartDate.Value & "# AND #" & Me.EndDate.Value & "#" However, looking at your...

I don't think you will have success with the On Activate event of the subform, as this event does not fire unless the subform is opened by itself (as a parent). When existing as a subform, the only attached event relative to the parent are "on enter" and "on exit" Pat's suggestion earlier...

Nice!

Check out "Continuous Forms" and Sub Forms in Help.

As an aside, avoid using the field name of "date". Date is a reserved word, and will cause headaches in further coding and date handling.

You are asking for grouping by Qty & UnitPrice, and then summing (Qty * Unitprice). thus if you have 2 seperate entries as below: Qty 1 UnitPrice $10 Qty 1 UnitPrice $10 it gets represented as a single entry (grouped) Qty 1 UnitPrice $10 Summed Total $20 To correct the issue, remove the...

My line of thought exactly. However, do not run the update query on the same table more than once unless you have a criteria statement active, or you will strip a name a second time. ie: MT<>PWI<>Smithopolous (1st action) gives Smithopolous (2nd time) gives ous (First nine characters removed)...