Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.08 seconds.
Search: Posts Made By: Gasman
Forum: Reports Today, 02:10 AM
Replies: 24
Views: 340
Posted By Gasman
Re: Restricted Employee Access to Reports

Just glad I got it right. :D
Forum: Forms Today, 02:04 AM
Replies: 12
Views: 1,346
Posted By Gasman
Re: Using DSum in a text box

Put the domain in double quotes as well?

https://support.office.com/en-us/article/dsum-function-08f8450e-3bf6-45e2-936f-386056e61a32
Forum: Reports Yesterday, 08:04 AM
Replies: 24
Views: 340
Posted By Gasman
Re: Restricted Employee Access to Reports

No, probably like


DoCmd.OpenReport reportname:="rptEmpActivity", WhereCondition:="[EmployeeID]=" & gEmployeeID , view:=acViewReport


TBH I have never used keyword parameters, just...
Forum: Reports Yesterday, 07:34 AM
Replies: 24
Views: 340
Posted By Gasman
Re: Restricted Employee Access to Reports

Normally to me, anything with ID in it would be numeric as I would take that to be an autonumber.?

Is that the case with you.?

If so, it should not be surrounded by single quotes, that is for...
Forum: Forms Yesterday, 01:42 AM
Replies: 16
Views: 286
Posted By Gasman
Re: Form for entering grades for children

If we are talking about form Grades for Classes K-12.

That is because the query for the form record source is not producing any records.?

That appears to be due to the fact that there are no...
Forum: Reports 07-17-2019, 02:06 AM
Replies: 24
Views: 340
Posted By Gasman
Re: Restricted Employee Access to Reports

Employee ID and EmployeeID are not the same?
Also if it is numeric do not use single quotes.
Forum: Forms 07-16-2019, 10:15 PM
Replies: 9
Views: 130
Posted By Gasman
Re: Hyperlink to Form

For the benefit of others, please explain what the problem was and how you solved it.

TIA
Forum: Forms 07-15-2019, 11:51 AM
Replies: 9
Views: 130
Posted By Gasman
Re: Hyperlink to Form

Inspect each variable.
That code expects a value for each variable. If one could be empty/null, you would need to do extra.
Forum: General 07-15-2019, 11:31 AM
Replies: 7
Views: 135
Posted By Gasman
Re: Open Forms in Datasheet View (All Records)

According to this link http://www.utteraccess.com/forum/open-form-datasheet-view-t1023173.html

you just specify the form view when opening?

DoCmd.OpenForm "frmEmails",acFormDS, stLinkCriteria
...
Forum: Forms 07-15-2019, 11:22 AM
Replies: 9
Views: 130
Posted By Gasman
Re: Hyperlink to Form

No, you only put the single quotes around the criteria


="[PMC]='" & [PMC] & "' And [cbstatus]='" In Progress & "'"
Forum: Forms 07-15-2019, 10:11 AM
Replies: 9
Views: 130
Posted By Gasman
Re: Hyperlink to Form

FWIW if you ever get to use dates, they should be surrounded by #.
Forum: Forms 07-15-2019, 09:47 AM
Replies: 9
Views: 130
Posted By Gasman
Re: Hyperlink to Form

PMC looks like text?

Text generally needs to be surrounded with single quotes.

Try

="[PMC]='" & [PMC] & "'"


HTH
Forum: Modules & VBA 07-15-2019, 05:05 AM
Replies: 13
Views: 184
Posted By Gasman
Re: Variables

Took me a while, I was wondering what the significance of the 134 was. :D
Forum: Modules & VBA 07-15-2019, 04:49 AM
Replies: 13
Views: 184
Posted By Gasman
Re: Variables

arnelgp,

Is that meant to be


Case Nz(Me.Frame112, 0) = 1 And Nz(Me.Frame134, 0) = 0
Forum: Modules & VBA 07-15-2019, 01:08 AM
Replies: 13
Views: 184
Posted By Gasman
Re: Variables

Does that even compile?

I would have coded it like this, which I have just tested and works?


Select Case Me.Frame10 And Me.Frame19
Case 1 And 1
Debug.Print "1and1"
Case 1...
Forum: Forms 07-14-2019, 10:14 AM
Replies: 24
Views: 303
Posted By Gasman
Re: Why doesn't the label stay on your Form

Tony.
The link for the class module does not work.?
Also says Product Not found
Forum: Forms 07-14-2019, 07:10 AM
Replies: 14
Views: 218
Posted By Gasman
Re: Change Color Of Sub-Form Row

Either apply the same criteria to every control in the row, or use a textbox as back fill as in the Emulated Split Form DB attached.?

Edit: I see theDBguy already mentioned this in post #2?
Forum: Forms 07-14-2019, 12:12 AM
Replies: 24
Views: 303
Posted By Gasman
Re: Why doesn't the label stay on your Form

No wonder I could not find it. :o
Forum: Forms 07-12-2019, 11:16 PM
Replies: 26
Views: 368
Posted By Gasman
Re: How to make a field mandatory

What should happen if I just choose to put a space in them?
Forum: Modules & VBA 07-12-2019, 11:08 PM
Replies: 36
Views: 549
Posted By Gasman
Re: Help to import text file of multiple formats

I would not be importing report output, but the data that created that report.?
Forum: Forms 07-12-2019, 05:55 AM
Replies: 12
Views: 197
Posted By Gasman
Re: Where clause does not work

Explain how you get it from the SQL process.
You need as shown, a value like "NOM Like 'b*'"
Forum: Forms 07-12-2019, 12:52 AM
Replies: 12
Views: 197
Posted By Gasman
Re: Where clause does not work

OK, still good practice to construct a string, especially if the criteria can be more complicated.?
Forum: Modules & VBA 07-12-2019, 12:39 AM
Replies: 6
Views: 158
Posted By Gasman
Re: Need help with INSERT INTO

Construct a string(s) with those values and Debug.Print it/them.?

Why does TxtFieldname not have any quotes?
Forum: Forms 07-12-2019, 12:35 AM
Replies: 12
Views: 197
Posted By Gasman
Re: Where clause does not work

"NOM Like 'b*'"


Do not really see the point of hard coding values though?:confused:

I would still construct it as Minty suggested, as then you can Debug.Print the string to see if the syntax...
Forum: Forms 07-12-2019, 12:28 AM
Replies: 12
Views: 197
Posted By Gasman
Re: Where clause does not work

Minty,

Would that not be


strWhere = "F01 = #" & V01 & "#"
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:33 PM.


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