Search results

Yep, all the same brand, specs, software, etc. I haven't changed any settings It will work on another user's pc for them... but not for me. So presume that my profile is doing something odd that their's isn't.

It looks like cpu usage is at 99% on both pc's when running query. I have tried running this on my machine with no other applications open and it is still very poor performance-wise. Incidentally, I have logged on to another machine with the same specs and it runs poorly on the other machine as...

Afternoon Folks, I have a database that multiple users have access to. We all have new pcs of exactly the same spec. We all have the same oracle ODBC, which is linking to tables in an oracle database on a Sun F15k Server. The linked tables are set-up using my oracle account with saved...

Try looking at this sample db... should be fairly straight forward. J

Smart has described it pretty well below... changes as follows: 1/ Try having a form (form1) with 2 combo boxes (each combo box will be based on a separate query) 2/ Create another query that selects your records. This query must include the 2 fields that are stored in your combo boxes...

Add another field for group priority and sort by that.

Try adding a reference to save the file in your loop. ... oWS.Visible = xlSheetVeryHidden oWS.Save End With oWS.Quit Set oApp = nothing Set oWB = nothing Set oWS = nothing

Look for help on "TransferSpreadsheet"... you will find everything that you need there.

Try looking at Tools, Start-up, display form. It is possible that you set-up a switchboard through the wizard and then changed the forms name?! If so, change the display form name to suit your current form name.

Bobby, If you post a sample database with just the basics and dummy records I can take a look for you. Please save as Access 97 if you want me to help. James

In a nutshell without crazy code or anything you could try the wizard. Create a basic form. Add a combo box. When the wizard appears select "Find a record on my form based on a value I select in my combo box."

p.s. the reason you are inputting your own email address at this stage is to see that it works and to test it. Obviously you would replace it with recipients address when you are happy.

Jake - I spotted that you were new... and hence offered you the easiest solution above. Goto Macros tab and click new. Select Sendobject from the drop-down menu. Select the relevant action arguments from the bottom of the macro form. In this case your object type would be report, choose your...

Sounds like you are new to access. The easy way is to create a macro and look at the sendobject action. It has easy dropdowns to navigate and understand. A a command button to your form that calls the macro. J

Bobby, I presume you must need all of the fields on your report, so a group-by was never going to work anyway. Open the Report in Design View, Right click the top left corner. Choose Sorting and grouping and add a field for City. This will add an extra level to your report. Place the fields...

Bobby, It sounds like you need to look at the sorting and grouping properties of your report. Open the report in design view. Right Click on the top left corner and select option sorting and grouping. Experiment with different options. If you run the query on it's own with group by on you...

You could put the following in the criteria section of a subsequent query... and then use this query as the basis for a form, report, etc. Between [forms]![FormName]![FirstDateParam] And [forms]![FormName]![SecondDateParam]

Open your query in design view. Right click on one of the fields you are selecting. Select "totals". This will make your query group by city, county and state.

Maybe you could try something like: - Copy the table - Delete one column in the copied table - Make your adjustments to the copied table - Paste the extra column back in to the copied table. - Delete original table. - Rename copied table to original table name. ** Obviously back up the whole...

Take a look at the following... Function Export_To_Excel() Dim dbs As Database Dim rst_WrkShtName Dim WrkShtName As String Dim qdfTemp As QueryDef DoCmd.SetWarnings False Set dbs = CurrentDb '-- Use this query to find a field to be used as names for the worksheets Set rst_WrkShtName =...