Go Back   Access World Forums > Search Forums

 
Showing results 1 to 8 of 8
Search took 0.00 seconds.
Search: Posts Made By: wilder20
Forum: Modules & VBA 09-15-2019, 02:43 PM
Replies: 15
Views: 280
Posted By wilder20
Re: Update Statement with a listbox Filtering & Combobaox

Basically the listbox shows what equipment is available to be transferred, the db does not know what equipment is being transferred there is not a way to filter it out because a person decides what...
Forum: Modules & VBA 09-15-2019, 11:26 AM
Replies: 15
Views: 280
Posted By wilder20
Re: Update Statement with a listbox Filtering & Combobaox

Thank you for your assistance/work, creating the message box and it works great. I will now continue creating the rest of the db. I will have to learn how to work with strings they allow for more...
Forum: Modules & VBA 09-15-2019, 08:22 AM
Replies: 15
Views: 280
Posted By wilder20
Re: Update Statement with a listbox Filtering & Combobaox

Attached is as requested, and thank you for all the help.
Forum: Modules & VBA 09-14-2019, 11:28 AM
Replies: 15
Views: 280
Posted By wilder20
Re: Update Statement with a listbox Filtering & Combobaox

I appreciate the help, and any thing that helps to get this working the way I am things would be great.

I received another runtime error 3144

Syntax error in UPDATE Statement

FYI, if I...
Forum: Modules & VBA 09-14-2019, 07:53 AM
Replies: 15
Views: 280
Posted By wilder20
Re: Update Statement with a listbox Filtering & Combobaox

Sorry to say that did not work, received another run-time error '3075'
Syntax error (messing operator) in query expression '[LSN] in (1A1256B)'

1a is a SN
Forum: Modules & VBA 09-14-2019, 04:57 AM
Replies: 15
Views: 280
Posted By wilder20
Re: Update Statement with a listbox Filtering & Combobaox

Thank you, I received an run-time error '3075':
Syntax error (missing operator) in query expression 'Raeford, NC'

It shows the error on the CurrentDb.Execute line

I do not understand string...
Forum: Modules & VBA 09-14-2019, 04:22 AM
Replies: 15
Views: 280
Posted By wilder20
Re: Update Statement with a listbox Filtering & Combobaox

I did think about the update query, but I could not think of how to filter down to only show the records that need to be updated or am I thinking how a update query works that it updates all records...
Forum: Modules & VBA 09-14-2019, 03:16 AM
Replies: 15
Views: 280
Posted By wilder20
Exclamation Update Statement with a listbox Filtering & Combobaox

Thank you for your help,

I am trying to update records in a table with the update statement, By using a unbound Listbox [SN] that shows serial#(s) (stored as text) (able to select Multi) primary...
Showing results 1 to 8 of 8

 
Forum Jump



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