Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: Gasman
Forum: Queries 02-13-2018, 12:59 PM
Replies: 17
Views: 246
Posted By Gasman
Forum: Modules & VBA 02-08-2018, 12:54 PM
Replies: 24
Views: 459
Posted By Gasman
Re: Make the text in a textbox scrolling horizontally in a form

No Colin, I had a quick peek when I had a spare moment, and then went on holiday. :D

Will look at it more closely when I get back.
Forum: Modules & VBA 02-07-2018, 03:16 AM
Replies: 24
Views: 459
Posted By Gasman
Re: Make the text in a textbox scrolling horizontally in a form

Pad out the end of the string with a required number of spaces?
Forum: Modules & VBA 02-05-2018, 10:43 AM
Replies: 24
Views: 459
Posted By Gasman
Re: Make the text in a textbox scrolling horizontally in a form

Colin,
I had a quick peek before I left work today.
Once you click the scrolling text button, if you click it again, is it meant to reset itself, in that the it stops and clears the scrolling text?...
Forum: Modules & VBA 02-05-2018, 06:47 AM
Replies: 5
Views: 159
Posted By Gasman
Re: Dealing with multiple Empty fields in a label

Test for NULL and then only add the string if not null?

Also I'd probably get the whole record in one pass with a recordset instead of all those DLookups?
Forum: Forms 02-04-2018, 09:15 AM
Replies: 12
Views: 212
Posted By Gasman
Re: Filter multiple criteria

Order_Complete = False

then add

debug.print strFilter
or
MSGBOX strFilter

to see what is produced
Forum: Forms 02-04-2018, 05:25 AM
Replies: 12
Views: 212
Posted By Gasman
Re: Filter multiple criteria

I think you will need to add the strings
I'm surprised it works at all as strfilter is not set?
I'd also check your string is formatted as you think it is, wouldn't you just want
Order_Complete...
Forum: The Watercooler 02-03-2018, 11:59 AM
Replies: 15
Views: 601
Posted By Gasman
Re: Commute Entertainment Technology Ideas?

Use this to get video/audio from YouTube

https://www.onlinevideoconverter.com/video-converter
Forum: General 02-02-2018, 09:12 AM
Replies: 9
Views: 178
Posted By Gasman
Re: Expected variable or procedure not project?

Ah that explains it. :D

I created a DB called Dlookup to be able to post here and was using the Dlookup function to see if it did the same before posting.

One to remember.

Thank you.
Forum: General 02-02-2018, 09:09 AM
Replies: 9
Views: 178
Posted By Gasman
Re: Expected variable or procedure not project?

Yes, I would have created them to try and speed things up. I have a pic os what was there and will see how it performs without them.
There is not a lot of data (at least at present) so will just see...
Forum: Forms 02-02-2018, 04:51 AM
Replies: 16
Views: 283
Posted By Gasman
Re: Hide Button

Are you sure?, I believe you could have used my first attempt in that case, just testing whether true or not?
Forum: The Watercooler 02-02-2018, 04:24 AM
Replies: 15
Views: 601
Posted By Gasman
Re: Commute Entertainment Technology Ideas?

Get signed up at the library, ours even do electronic versions as well.:cool:
Forum: The Watercooler 02-02-2018, 04:22 AM
Replies: 15
Views: 601
Posted By Gasman
Re: Commute Entertainment Technology Ideas?

I just tend to use the online converters/downloaders? for mp3 or mp4
Forum: The Watercooler 02-02-2018, 04:21 AM
Replies: 15
Views: 601
Posted By Gasman
Forum: General 02-02-2018, 04:18 AM
Replies: 9
Views: 178
Posted By Gasman
Re: Expected variable or procedure not project?

I've replaced the table with a query for now, that also allows me to filter by the record type (perhaps a better way anyway?).

This would happen just as I am going on holiday. ;), been working...
Forum: General 02-02-2018, 03:45 AM
Replies: 9
Views: 178
Posted By Gasman
Re: Expected variable or procedure not project?

OK, something has gone screwy somewhere.
I would always put in the many record with a certian record type first and then the other record type second.
For this set they were the other way around if...
Forum: General 02-02-2018, 03:34 AM
Replies: 9
Views: 178
Posted By Gasman
Re: Expected variable or procedure not project?

Hi Minty,

Thanks for the quick reply.

I went into the BE and sure enough I had a few indices set, so I removed all but the PK and the TransferID which I was using as the lookup value.
Still...
Forum: General 02-02-2018, 03:12 AM
Replies: 9
Views: 178
Posted By Gasman
Expected variable or procedure not project?

Hi all,

I was trying to post a problem I was having with DLookup.
To try and show the problem better I was going to upload a DB with the two tables in question.
However after exporting them to a...
Forum: The Watercooler 02-01-2018, 12:44 PM
Replies: 15
Views: 601
Posted By Gasman
Re: Commute Entertainment Technology Ideas?

I wanted to put ALL my music on the Fire, so bought a 128GB card.

I also get video/music from the likes of Youtube and put on the tablet.
Forum: The Watercooler 02-01-2018, 12:41 PM
Replies: 15
Views: 601
Posted By Gasman
Re: Commute Entertainment Technology Ideas?

I'm on my third tablet, all working :D and really like the Amazon Fire (My 3rd) and it's price.

Good to start of with at least.
Forum: Forms 02-01-2018, 09:09 AM
Replies: 6
Views: 149
Posted By Gasman
Re: Multiple Names from Form

I believe you would need
Meeting table
Attendee table
and a link table that links Attendees to Meetings

HTH
Forum: General 02-01-2018, 09:06 AM
Replies: 11
Views: 330
Posted By Gasman
Re: Open report based on combo box selection

I do that with a system I have just created.
I have an object table that holds value of "query", "form", or "report", object name with descriptive name for a combo and ability to add a where clause,...
Forum: General 02-01-2018, 06:56 AM
Replies: 11
Views: 330
Posted By Gasman
Re: Open report based on combo box selection

I approached that sort of problem like this


Private Sub cmdOpen_Click()
' Open report for all or a certain submitter
If Me.cboSubmitter = 0 Then ' Combo shows ALL
DoCmd.OpenReport...
Forum: Tables 02-01-2018, 06:50 AM
Replies: 10
Views: 263
Posted By Gasman
Re: help with inventory design

Might be part of his thesis?

https://access-programmers.co.uk/forums/showthread.php?t=298110
Forum: Forms 02-01-2018, 05:03 AM
Replies: 16
Views: 283
Posted By Gasman
Re: Hide Button

You do not need two buttons.
You need one button hidden or not. That button will open your form.


Private Sub Form_Current()

If Me.DualMasterLoaded = "No" Then
Me.Link.Visible = True...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:48 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World