Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: Gasman
Forum: Forms Today, 01:31 AM
Replies: 4
Views: 59
Posted By Gasman
Re: displaying data from an xml file on a form

Just to throw another option in there, you can use csv format as well?
...
Forum: General Today, 01:20 AM
Replies: 4
Views: 59
Posted By Gasman
Re: Backup a Backend - enhanced

I thought this was for an Access BE ?
Forum: Reports Today, 01:05 AM
Replies: 3
Views: 35
Posted By Gasman
Re: Export multiple PDF reports with recordset loop VBA

I'd be walking through the code line by line in the debugger.

Your parameter needs to be surrounded by single quotes or triple double quotes if there is a chance of a single quote in the...
Forum: Reports Yesterday, 02:10 AM
Replies: 24
Views: 344
Posted By Gasman
Re: Restricted Employee Access to Reports

Just glad I got it right. :D
Forum: Forms Yesterday, 02:04 AM
Replies: 12
Views: 1,350
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 07-18-2019, 08:04 AM
Replies: 24
Views: 344
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 07-18-2019, 07:34 AM
Replies: 24
Views: 344
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 07-18-2019, 01:42 AM
Replies: 16
Views: 287
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: 344
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: 131
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: 131
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: 139
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: 131
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: 131
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: 131
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: 185
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: 185
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: 185
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: 369
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: 560
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.?
Showing results 1 to 25 of 500

 
Forum Jump



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