Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.12 seconds.
Search: Posts Made By: GinaWhipp
Forum: Forms 12-09-2019, 08:08 AM
Replies: 21
Views: 267
Posted By GinaWhipp
Re: Incremental Numbering on a Continuous Form

Hmm, thinking this might help...
https://www.access-diva.com/vba7.html
Forum: Queries 12-01-2019, 11:30 PM
Replies: 3
Views: 96
Posted By GinaWhipp
Re: Is not Null

The field may not be NULL, it may just be EMPTY which is why Is Not Null is not working. Try using...
<>""
Forum: The Watercooler 12-01-2019, 05:00 PM
Replies: 40
Views: 602
Posted By GinaWhipp
Re: What's your favorite movie quote?

The only thing I remember from Tremors 2 is that line (and Burt) so I guess that emphasizes how good it was.
Forum: The Watercooler 12-01-2019, 01:36 PM
Replies: 40
Views: 602
Posted By GinaWhipp
Re: What's your favorite movie quote?

From Tremors 2...

"I feel I was denied critical, need-to-know information!"
Burt Gummer
Forum: Forms 11-17-2019, 11:20 AM
Replies: 12
Views: 214
Posted By GinaWhipp
Re: Removing Form Icon

Colin,

True, I just prefer to remove the icon and leave the border.
Forum: Forms 11-17-2019, 10:01 AM
Replies: 12
Views: 214
Posted By GinaWhipp
Re: Removing Form Icon

@Colin,

It is not a border-less Form. Go to any Form in Design View and set Control Box to No. You still have a border you just have no icon in the border. The down side is you also have no...
Forum: Forms 11-17-2019, 07:34 AM
Replies: 12
Views: 214
Posted By GinaWhipp
Re: Removing Form Icon

Hmm, if you put your own Close button and remove the Control Box there will be no Form icon.
Forum: Queries 11-06-2019, 07:37 AM
Replies: 15
Views: 423
Posted By GinaWhipp
Re: looking for IFF expression in query to calculate total cost

I'm not able to match up what you are asking with the image you provided. Please clarify.
Forum: Queries 11-02-2019, 09:58 AM
Replies: 8
Views: 223
Posted By GinaWhipp
Re: Two criteria

What happens if you remove the below from the Group By clause?

[Instruments list].[Instrument status2]
Forum: Queries 10-28-2019, 06:27 AM
Replies: 8
Views: 223
Posted By GinaWhipp
Re: Two criteria

Hmm, well it looks like Instrument Status2 might be preventing it from totaling on one line. What happens if you take that out of the GROUP BY? Oh and just noticed Calibrating Agency? Do those...
Forum: General 10-27-2019, 10:09 PM
Replies: 8
Views: 197
Posted By GinaWhipp
Re: column sort option greyed out

Hmm, wondering why you would do this in a Table. The more appropriate place would be in a query. You really don't want your Users in the Table.
Forum: Queries 10-27-2019, 09:55 PM
Replies: 8
Views: 223
Posted By GinaWhipp
Re: Two criteria

Are you using a Groups and Total query? Hmm, would help if you post the SQL of the query.
Forum: Forms 10-27-2019, 12:40 PM
Replies: 29
Views: 19,084
Posted By GinaWhipp
Re: Open Form with current record

Hmm, AND I see DBGuy is doing quite a bang up job.... moving along now.
Forum: Forms 10-27-2019, 09:24 AM
Replies: 29
Views: 19,084
Posted By GinaWhipp
Re: Open Form with current record

What error message are you getting? For that matter what are you trying to Save before closing frmSearchAppointmentsBetween2DatesBYDOCNAME?
Forum: Queries 10-27-2019, 09:17 AM
Replies: 15
Views: 423
Posted By GinaWhipp
Re: looking for IFF expression in query to calculate total cost

Hmm, I believe you are trying to use Access tables like Excel spreadsheets which they are not. To get to the below you create a Table for input, i.e.

tblInput (using name for example only)...
Forum: Queries 10-26-2019, 11:22 AM
Replies: 15
Views: 423
Posted By GinaWhipp
Re: looking for IFF expression in query to calculate total cost

The suggested solution it in Duane's response which is the same as the one posted by arnelop above.

Tables should not have field names like Q1..., Q2... They should be long not wide. If you post...
Forum: Queries 10-25-2019, 08:00 AM
Replies: 15
Views: 423
Posted By GinaWhipp
Re: looking for IFF expression in query to calculate total cost

Looks like Duane has posted a solution in the other Forum. That said, you may want to take to take a step back and learn about normalization as if this is the beginning of your database you are...
Forum: Queries 10-24-2019, 11:50 PM
Replies: 15
Views: 423
Posted By GinaWhipp
Re: looking for IFF expression in query to calculate total cost

Hmm, is the same that is posted here...
https://answers.microsoft.com/en-us/msoffice/forum/all/looking-for-iff-expression-in-query-to-calculate/956c7eb8-1d03-4f69-ae27-6df617472f86
Forum: General 10-10-2019, 10:39 PM
Replies: 7
Views: 129
Posted By GinaWhipp
Re: duplicate record

Hmm, in the code to duplicate the record set Allow Edits to True, duplicate the record and then set it back to Allow Edits False. Will happen fast enough that no one will notice.
Forum: Modules & VBA 10-07-2019, 11:06 PM
Replies: 9
Views: 8,820
Posted By GinaWhipp
Re: Can't Hide Control that has the focus

Or you could add a little tiny text box in the corner and set the focus to it.
Forum: General 10-07-2019, 04:48 PM
Replies: 13
Views: 297
Posted By GinaWhipp
Re: Microsoft Access Forms Review for Suggestions.

Hmm, so did I miss the part with the Relationships window? Seems like some work needs to be done there.
Forum: Forms 10-07-2019, 12:29 PM
Replies: 12
Views: 229
Posted By GinaWhipp
Re: How to set image for button hover

I think this will give you what you want...
https://www.access-diva.com/vba22.html
Forum: The Watercooler 09-28-2019, 11:09 PM
Replies: 50
Views: 959
Posted By GinaWhipp
Re: Distractions, Distractions, Distractions

I have no idea as every few years there's ANOTHER study. I just know it's a fact from years ago. I forget which movie it was I was watching but when it was stated I then had to go verify and low...
Forum: The Watercooler 09-28-2019, 08:52 AM
Replies: 50
Views: 959
Posted By GinaWhipp
Re: Distractions, Distractions, Distractions

Hmm, well scientific fact, men are more likely to hit by lightening than women. So be careful out there!
Forum: Modules & VBA 09-26-2019, 08:50 AM
Replies: 5
Views: 105
Posted By GinaWhipp
Re: Spell Check For Multiple TextBoxes

I took Arvin's code and modified slightly to only check cream colored controls. Then you just need to change the back color for the text boxes you want to apply spell check to and you only get one...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:30 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