Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 135
Search took 0.01 seconds.
Search: Posts Made By: r.harrison
Forum: Modules & VBA 05-25-2012, 07:09 AM
Replies: 4
Views: 684
Posted By r.harrison
Re: Different Results From Query and VBA

Have you tried importing the query directly to Excel instead of through code?

Data - External Data - Access

?
Forum: Modules & VBA 05-25-2012, 06:16 AM
Replies: 4
Views: 684
Posted By r.harrison
Re: Different Results From Query and VBA

Hi Evilbungle,

Have you tried opening the table and filtering the results to see how many records the query should return?

Rich
Forum: General 11-10-2011, 08:38 AM
Replies: 19
Views: 210,618
Posted By r.harrison
Re: Load form on startup in Access 2007

Another option is to hold down the Shift Key while opening the database.

This bypasses the startup form, re-instates the nav bar and all context menus (If you had disabled them).
Forum: Queries 11-03-2011, 06:06 AM
Replies: 3
Views: 1,222
Posted By r.harrison
Re: Autofilter Access 2003??

you can try using an iif statement.
Forum: Queries 11-03-2011, 01:28 AM
Replies: 3
Views: 1,222
Posted By r.harrison
Re: Autofilter Access 2003??

Hi,

I haven't tested this, but I think using NZ in the query instead of the Or statements might work.

WHERE (([Satellite Launches].Launcher=Nz([Forms]![QBF_Form_F]![Launcher] ,"") AND ....
Forum: Excel 10-29-2011, 09:48 AM
Replies: 3
Views: 3,856
Posted By r.harrison
Re: Sending data from Excel to Access

Hi,

In your do ... loop you are adding data to different fields, but using the same excel cell (A & r).

This will make every field in the table the same.
Forum: Forms 10-29-2011, 09:42 AM
Replies: 9
Views: 1,518
Posted By r.harrison
Re: DateDiff Hoours and Minutes

Hi,

You would need to use an if statement.

if StartTime > Finishtime then elapsedtime=elapsedtime+24

or something similar.
Forum: Forms 10-28-2011, 01:47 AM
Replies: 2
Views: 1,412
Posted By r.harrison
Re: Filter Subform from user input

Hi,

You can filter on as many fields as you like. Just use 'AND' after each item
i.e.


With Me.frmsub.Form
.Filter = "[Franchise] = 'Abarth' AND [YourField] = '" & [YourTextBox] & "'"...
Forum: General 10-28-2011, 12:25 AM
Replies: 7
Views: 922
Posted By r.harrison
Re: Formulas

Just reading back through, in your table you have 8 fields. What are all the field names?
Forum: General 10-28-2011, 12:18 AM
Replies: 7
Views: 922
Posted By r.harrison
Re: Formulas

So effectively the query will search for each instance of any ingredient and then total it up. Kind of like a shopping list?
Forum: General 10-28-2011, 12:13 AM
Replies: 7
Views: 922
Posted By r.harrison
Re: Formulas

You can use either a form of query.

Are you trying to get the total of each column, or the sum of one or more fields in each row?
Forum: Macros 10-28-2011, 12:10 AM
Replies: 2
Views: 2,854
Posted By r.harrison
Re: Running excel macro as part of my Access 2007 macro.

Could you not modify the report before the export process?
Forum: Forms 10-28-2011, 12:06 AM
Replies: 1
Views: 493
Posted By r.harrison
Re: Switchboard to form to last record

after the open form command, add a gotorecord,,aclast
Forum: Queries 10-27-2011, 11:53 AM
Replies: 7
Views: 1,300
Posted By r.harrison
Re: Attaching a Query to a Form

Hi,

A quick idea for you would be to have a combobox which looks up the UPC from your table. Then have the Record Source for the form which filters the results based on the combobox

Then all...
Forum: General 10-20-2011, 05:40 AM
Replies: 24
Views: 16,685
Posted By r.harrison
Re: Problem installing Access 2010 Runtime

Finally got it working again. Full uninstall and re-install thanks MS!
Forum: General 10-20-2011, 05:26 AM
Replies: 24
Views: 16,685
Posted By r.harrison
Re: Problem installing Access 2010 Runtime

Already tried that. Nearly finished re-install now anyway. Fingers crossed this fixes the bug.

From what I can gather from other posts it's the runtime has 'over written' some of the registry keys...
Forum: General 10-20-2011, 05:02 AM
Replies: 24
Views: 16,685
Posted By r.harrison
Re: Problem installing Access 2010 Runtime

Just come across a new issue with this.

I have 2010 on this machine. Downloaded the runtime for deployment on other comps. Thought I'd test it on here first.

Runtime installed without any...
Forum: Forms 10-19-2011, 02:22 AM
Replies: 8
Views: 1,623
Posted By r.harrison
Re: If text string matches while typing then need related text to auto appear in comb

I thought the OnChange event only fires once i.e on the first keypress?
Forum: Forms 10-19-2011, 02:05 AM
Replies: 8
Views: 1,623
Posted By r.harrison
Re: If text string matches while typing then need related text to auto appear in comb

If you really want it to update as you type then you'll need to look at the Keydown, Keypress, KeyUp events.

I have done this before just because it looks good. But as vbaInet says, much easier...
Forum: Forms 10-19-2011, 01:28 AM
Replies: 8
Views: 1,623
Posted By r.harrison
Re: If text string matches while typing then need related text to auto appear in comb

Hi Moto,

I've looked at your DB, as Alanisdman said, you need to normalise the tables

Check the attachment for a quick idea.
Forum: Queries 10-19-2011, 01:16 AM
Replies: 6
Views: 599
Posted By r.harrison
Re: Using an updatable constant in a query

Hi,

Just a quick question. Do you need to store the month end figures in a table or just run a query each month to get the total?
Forum: Tables 10-19-2011, 01:06 AM
Replies: 13
Views: 1,994
Posted By r.harrison
Re: Normalization of tables

Hi,

I've looked at the tables and have a few suggestions:

The Employee table looks fine, but some of the others are a little off.

Taking the Positions table. You would only need about 3...
Forum: Modules & VBA 10-19-2011, 12:58 AM
Replies: 6
Views: 1,175
Posted By r.harrison
Re: For Each Record in Table ....?

Hi,



I think an SQL statement will be what you're looking for.

Try CurrentDB.Execute ("UPDATE [GL_LINES] SET [GL_LINE_FLAG] = 1 WHERE [LINE_ID] = " & Forms!frm_LINES_ALL.LINE_ID.Value & ";")...
Forum: Forms 10-19-2011, 12:48 AM
Replies: 5
Views: 1,579
Posted By r.harrison
Re: Help With Save Button

Hi,

If it's only ID's you need to store then set the First name, surname fields as they are, then set the rest as Lookup fields.
Forum: Forms 10-18-2011, 10:34 AM
Replies: 5
Views: 1,579
Posted By r.harrison
Re: Help With Save Button

Hi,

I'm not overly sure what it is you're trying to do. But a Query does not store data. The query simply looks up the information from a table.

To be able to see the info in the query it would...
Showing results 1 to 25 of 135

 
Forum Jump



All times are GMT -8. The time now is 12:59 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World