Go Back   Access World Forums > Search Forums

 
Showing results 1 to 22 of 22
Search took 0.01 seconds.
Search: Posts Made By: L0b0
Forum: Modules & VBA 03-04-2019, 08:22 AM
Replies: 4
Views: 99
Posted By L0b0
Re: Run-Time error '3075'

That did it!:banghead: Thank you!
Forum: Modules & VBA 03-04-2019, 08:11 AM
Replies: 4
Views: 99
Posted By L0b0
Run-Time error '3075'

I keep getting this run-time error and im not sure why. Its saying Syntax error (missing operator) in query expression 'Store Name = 'test store".
I have a list box thats connected to a Query and im...
Forum: Forms 02-28-2019, 04:54 PM
Replies: 14
Views: 171
Posted By L0b0
Re: Auto Fill based on last record entry

That's weird, I don't know why it isn't showing for me. This module works really well though. Thank you for your help!
Forum: Forms 02-28-2019, 04:50 PM
Replies: 14
Views: 171
Posted By L0b0
Re: Auto Fill based on last record entry

http://allenbrowne.com/ser-24.html this actually seems to work very well
Forum: Forms 02-28-2019, 04:38 PM
Replies: 14
Views: 171
Posted By L0b0
Re: Auto Fill based on last record entry

oh shoot my bad I thought I decrypted it.

74140
Forum: Forms 02-28-2019, 04:31 PM
Replies: 14
Views: 171
Posted By L0b0
Re: Auto Fill based on last record entry

I was testing it with the form labeled TESTupdates and for the moment the Order Amount field. It doesn't seem to work for me.
Forum: Forms 02-28-2019, 02:04 PM
Replies: 14
Views: 171
Posted By L0b0
Re: Auto Fill based on last record entry

I thought so but it doesnt seem to be doing anything for me.
Forum: Forms 02-27-2019, 11:51 AM
Replies: 14
Views: 171
Posted By L0b0
Re: Auto Fill based on last record entry

Ah yes, I would like to use it on the onload. But what values am I exactly changing in the code to match mine?
Forum: Forms 02-27-2019, 11:28 AM
Replies: 14
Views: 171
Posted By L0b0
Re: Auto Fill based on last record entry

This looks like what i'm looking for! How do I set this up?
Forum: Forms 02-27-2019, 11:05 AM
Replies: 14
Views: 171
Posted By L0b0
Auto Fill based on last record entry

How might I go about setting up a form to auto-fill any information that was entered in the last record, based on a lookup field? I dont want to change the original record, I want it to just populate...
Forum: Macros 02-07-2019, 03:09 PM
Replies: 6
Views: 188
Posted By L0b0
Re: Search

the newest, which I picked up through Microsofts essentials plan. I assume its the newest its webapp based
Forum: Macros 02-07-2019, 02:57 PM
Replies: 6
Views: 188
Posted By L0b0
Re: Search

I was using it in sharepoint. I put one on sharepoint to play with in the browser.
Forum: Macros 02-07-2019, 02:35 PM
Replies: 6
Views: 188
Posted By L0b0
Re: Search

VBA cant be used in the browser though? :/ Is there a alternative close to this I could use with macros?
Forum: Macros 02-07-2019, 11:43 AM
Replies: 6
Views: 188
Posted By L0b0
Question Search

access-programmers.co.uk/forums/showthread.php?t=188663

Is there a way of doing this with macros for use in browser? I have a hard time with macro syntax.
Forum: Forms 02-06-2019, 10:29 AM
Replies: 16
Views: 106
Posted By L0b0
Re: Search Form

Yea I managed to get the macro for the open form. Just trying to get the syntax right for the search. Thanks
Forum: Forms 02-06-2019, 08:55 AM
Replies: 16
Views: 106
Posted By L0b0
Re: Search Form

Slight dig, but if I wanted to convert this now to a web form, is there any way of doing that? Could I pull off the same code with just a macro?
Forum: Forms 01-28-2019, 08:37 AM
Replies: 16
Views: 106
Posted By L0b0
Re: Search Form

Thank you! That fixed it!
Forum: Forms 01-28-2019, 08:27 AM
Replies: 16
Views: 106
Posted By L0b0
Re: Search Form

SELECT [QRY_SearchAll].[Ref Date], [QRY_SearchAll].[Representative], [QRY_SearchAll].[Retailer], [QRY_SearchAll].[City], [QRY_SearchAll].[State], [QRY_SearchAll].[Contact], [QRY_SearchAll].[Time In],...
Forum: Forms 01-28-2019, 07:49 AM
Replies: 16
Views: 106
Posted By L0b0
Re: Search Form

Thats weird cause its not showing the .column(2) on my end. I changed it to .column(3) to fix it? But its not showing still?
Forum: Forms 01-25-2019, 07:26 PM
Replies: 16
Views: 106
Posted By L0b0
Re: Search Form

73561I had it bound but it wasn't working for me unless I messed up something.
Forum: Forms 01-25-2019, 11:38 AM
Replies: 16
Views: 106
Posted By L0b0
Re: Search Form

Thanks! This is actually really nice, its opening the form I want now but its not displaying the value? On the second form I set the record source to my same query and the fields unbound. One of the...
Forum: Forms 01-25-2019, 10:15 AM
Replies: 16
Views: 106
Posted By L0b0
Question Search Form

I'm currently using this /forums/showthread.php?t=188663 to create a search form. This works great but I would also like to add some text boxes to display the memo fields that are associated with the...
Showing results 1 to 22 of 22

 
Forum Jump



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