Go Back   Access World Forums > Search Forums

Showing results 1 to 15 of 15
Search took 0.08 seconds.
Search: Posts Made By: deanvilar
Forum: Modules & VBA 06-08-2013, 04:00 AM
Replies: 4
Views: 523
Posted By JHB
Re: String selection

Try Left(Me.txt, len(Me.Txt)-6)
Forum: Queries 06-05-2013, 09:26 PM
Replies: 7
Views: 1,693
Posted By Pat Hartman
Re: how to query Select Distinct field + showing other fields?

Unless there are more columns that can't actually be grouped, a simple totals query would do the job.
in the QBE, select the three columns
Press the sigma button to create the totals query. Access...
Forum: Queries 06-04-2013, 10:33 PM
Replies: 7
Views: 1,693
Posted By Brianwarnock
Re: how to query Select Distinct field + showing other fields?

I'm about to go walking so don't have much time but this is a basic approach to things like finding the data to go with a particular max value be it a date or your increment number. Normally two...
Forum: Modules & VBA 06-02-2013, 09:58 PM
Replies: 3
Views: 506
Posted By Galaxiom
Re: How would I call goTo goHere: from another form?

The procedure must be declared as Public in the form's module.
Forum: Queries 05-03-2013, 05:18 AM
Replies: 5
Views: 595
Posted By jdraw
Re: Create query from a different database to populate a combobox

Well, the first option that comes to mind is to
-link to the database that has the table with the info you want to use.

see http://www.techonthenet.com/access/tables/link_table2007.php
Forum: Modules & VBA 05-01-2013, 11:59 AM
Replies: 5
Views: 761
Posted By gemma-the-husky
Re: Date >=startdate <=enddate not functionin

you need similar to this

cdate >= startdate and cdate <= enddate


cdate between startdate and enddate

note that if you are in the UK, you may need to disamibguate the...
Forum: Modules & VBA 05-01-2013, 11:43 AM
Replies: 5
Views: 761
Posted By mdlueck
Re: Date >=startdate <=enddate not functionin

Your provided code is comparing between three total dates. VBA If statements I do not believe are not capable of evaluating three things directly without grouping parenthesis to work within the...
Forum: General 04-08-2013, 02:17 AM
Replies: 11
Views: 2,017
Posted By pr2-eugin
Re: Invalid operation after database split fe/be

This link (http://support.microsoft.com/kb/109218) might be of interest to you.
Forum: Modules & VBA 04-07-2013, 09:16 AM
Replies: 6
Views: 2,163
Posted By Solo712
Re: DLAST function, results not showing

Assuming that DocLogNo is the primary key then you would do
= Nz(DMax("DocLogNo", "documentLog"))
You can create criteria the same way you did with the DLast. So, eg. if you were searching for...
Forum: Modules & VBA 04-01-2013, 10:58 AM
Replies: 10
Views: 1,391
Posted By Solo712
Re: Fetch last record number then + 1 automatically

You've got a zero missing in the highlighed place. :)

Forum: Reports 03-31-2013, 10:52 AM
Replies: 3
Views: 959
Posted By pbaldy
Forum: Reports 03-30-2013, 10:18 PM
Replies: 3
Views: 959
Posted By pbaldy
Re: Null table field will not include in report

Base the report on a query with

Is Not Null

in the criteria for that field.
Forum: Reports 02-16-2010, 06:05 AM
Replies: 8
Views: 12,929
Posted By Magster
Re: How to hide rows in a report?

Hi - I'm an oldtime programmer so I never learned much about macros, so I'll explain code - VBA. Although I think macros are a great learning tool if you take the time to convert them and understand...
Forum: Forms 03-31-2006, 04:01 PM
Replies: 4
Views: 24,996
Posted By Vassago
Row Source = SELECT distinct Tasks.Milestones...

Row Source = SELECT distinct Tasks.Milestones FROM Tasks;
Forum: General 07-18-2003, 05:17 AM
Replies: 32
Views: 77,745
Posted By MadMaxx
Disable Shift Key

Because this was brought up in my previous post here is the solution to disable the user from using the shift key to access the database window during startup.

1. Create a new module and past this...
Showing results 1 to 15 of 15

Forum Jump

All times are GMT -8. The time now is 05:29 AM.

Microsoft Access Help
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