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 11-17-2019, 11:20 AM
Replies: 12
Views: 188
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: 188
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: 188
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: 364
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: 189
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: 189
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: 176
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: 189
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: 18,964
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: 18,964
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: 364
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: 364
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: 364
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: 364
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: 126
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,733
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: 291
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: 221
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: 892
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: 892
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...
Forum: Modules & VBA 09-25-2019, 10:09 PM
Replies: 11
Views: 169
Posted By GinaWhipp
Re: Duplication Code for Main Form and five Sub-Form records

You can't have...
!PRODUCT_ID = Me.PRODUCT_ID

That is the PK for the current record, remove that. Are there any fields from the main record you want to carry over? Those are the only ones you...
Forum: The Watercooler 09-25-2019, 08:57 PM
Replies: 50
Views: 892
Posted By GinaWhipp
Re: Distractions, Distractions, Distractions

Not as bad as asking hubby to fix the leak under the sink and end up flooding the kitchen! Yes, that happened. And all we could is laugh to keep from crying.
Forum: The Watercooler 09-25-2019, 07:15 PM
Replies: 50
Views: 892
Posted By GinaWhipp
Re: Distractions, Distractions, Distractions

Hmm, this is one of the reason I have replace my machines every couple of years. The first time my hard drive crashed on me (it gave me warnings I ignored them) I lost a week of work. That was not...
Forum: Forms 09-25-2019, 07:01 PM
Replies: 8
Views: 158
Posted By GinaWhipp
Re: textbox locked and greyed

Maybe something like...

Wasn't sure if you meant they needed a password or not so I put some air code in there if you want them to enter one. Also, check boxes don't have a back color so can't...
Showing results 1 to 25 of 500

 
Forum Jump



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