Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 357
Search took 0.06 seconds.
Search: Posts Made By: murray83
Forum: Modules & VBA 11-22-2018, 05:10 AM
Replies: 6
Views: 326
Posted By murray83
Re: Send Keys in windows folder

Yes

would i define it some where or is it in the options in the property sheet
Forum: Modules & VBA 11-22-2018, 04:22 AM
Replies: 6
Views: 326
Posted By murray83
Re: Send Keys in windows folder

the folder is full of printers and i'm wanting to try and automate connecting to that printer (its not a normal a3 or a4 paper printer) for printing from database as not everybody is savvy on how to...
Forum: Modules & VBA 11-22-2018, 04:14 AM
Replies: 6
Views: 326
Posted By murray83
Send Keys in windows folder

Afternoon

i am trying to get send keys to move down to a specific location in a folder onced its been opened from the form in access

but all it seems to do is open many, many windows of the...
Forum: Reports 11-16-2018, 11:33 AM
Replies: 7
Views: 454
Posted By murray83
Talking Re: put picture on a report from path in a table

hold the bloody phone i may have cracked the searching lark

just came across this page https://bytes.com/topic/access/answers/876256-linking-picture-access-report

and this snippet of code
...
Forum: Reports 11-16-2018, 11:25 AM
Replies: 7
Views: 454
Posted By murray83
Re: put picture on a report from path in a table

for instance have tried this but i just have an empty image

Private Sub Report_Current()

If Me.txt_MULocation.Value = (DLookup("[Location]", "T_LocationBarcode", "[Location] =" &...
Forum: Reports 11-16-2018, 11:20 AM
Replies: 7
Views: 454
Posted By murray83
Re: put picture on a report from path in a table

its an option but i have more than one image so how would i differentiate on what is binded (bound even)
Forum: Reports 11-16-2018, 09:58 AM
Replies: 7
Views: 454
Posted By murray83
put picture on a report from path in a table

this is all back of the envelope coding

problem i have is i need to genereate a report which has a barcode on but we dont have barcode fonts (dont ask) so have used an online tool to generate...
Forum: Forms 11-15-2018, 12:59 PM
Replies: 4
Views: 356
Posted By murray83
Re: DLookup Text when using yes/no as criteria

you are AMAZING :D

enough said thanks
Forum: Forms 11-15-2018, 12:53 PM
Replies: 4
Views: 356
Posted By murray83
Re: DLookup Text when using yes/no as criteria

like this

=DLookUp("'[update]'","[T_Version_2]","[current]"=True)

or just get rid of the [ ] brackets and put this

=DLookUp("'[update]'","[T_Version_2]","current=True")

as with the last...
Forum: Forms 11-15-2018, 12:13 PM
Replies: 4
Views: 356
Posted By murray83
DLookup Text when using yes/no as criteria

Evenin

i have had a look around here for an answer to this and google but i still keep getting #type

code i have tried

=DLookUp("'[update]'","[T_Version_2]","[current]"=1)

and also with...
Forum: SQL Server 11-13-2018, 12:46 PM
Replies: 6
Views: 1,617
Posted By murray83
Re: multiple inner join

thanks a million million plog & isladogs

worked ( of course it did ) and v happy

cant belive that simple but when you look at it yeah how was it supposed to know which supplier id

cheers...
Forum: SQL Server 11-13-2018, 12:11 PM
Replies: 6
Views: 1,617
Posted By murray83
multiple inner join

good evening

have a question which i hipe you clever people can help with

facts first, I have 3 tables which i wish to pull data from

i am able to inner join table 2 to table 1 but then i...
Forum: Modules & VBA 10-29-2018, 02:00 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

ok ta for that one last thing i promise on this subject

when you open the database in the drop down box where you select the question set it states number 2 as well as 1

but i have no number 2...
Forum: Modules & VBA 10-26-2018, 11:56 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

trust me to try and be cleaver and go and break it

but thanks a lot for your help :)
Forum: Modules & VBA 10-26-2018, 05:36 AM
Replies: 35
Views: 580
Posted By murray83
Forum: Modules & VBA 10-25-2018, 07:04 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

extra pics as 5 is the max
Forum: Modules & VBA 10-25-2018, 07:03 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

OK step by step with photos as well

I open the database as the end user would no holidng shift or anything

so i enter my name, for this was joe blogs

and choose set 1 for questions and...
Forum: Modules & VBA 10-24-2018, 11:23 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

OK

after i had completed the quiz and asnwerd each right( as i set the questions) as wanted to see add it all up to grand total

but was only showing 2 right and then when i checked the...
Forum: Modules & VBA 10-24-2018, 09:48 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

amazing thank you, that is also a lot less code in the dcount one thing i have noticed from the attached you can see as well

that if you even give the correct answer as i was doing it puts the...
Forum: Modules & VBA 10-23-2018, 11:25 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

i have managed to fix the flag issue ater a long google found out i was supposed to put the path to the image in the table

but if you can help with the final score that would be great
Forum: Modules & VBA 10-23-2018, 07:25 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

ok thats fine but what is the folder setup for pictures as i have tried

picture or pictures

as it faults as cant load Slovakia flag picture

sorry also rather than dp ill edit this

on my...
Forum: Modules & VBA 10-22-2018, 08:50 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

one question how do i change the questions as i tried to change it so uses my questions which you have still in there but complains due to some linking of the tables
Forum: Modules & VBA 10-22-2018, 07:53 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

thanks shall check it out
Forum: Modules & VBA 10-19-2018, 03:36 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

tried this

RSlot(RSlot(4)) As Single

and got the attached named "Today's Error"


then tried this

RSlot(RSlot(4) As Single) = 0
Forum: Modules & VBA 10-18-2018, 05:19 AM
Replies: 35
Views: 580
Posted By murray83
Re: How Can I Remove two random buttons

cheers, ok almost working but having some fun with the correct slot, which i will work on later

and yes the buttons are visible on form open/load
Showing results 1 to 25 of 357

 
Forum Jump



All times are GMT -8. The time now is 03:56 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World