Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Kingz's latest activity
K
Kingz
replied to the thread
Solved
Dynamic Insert statement
.
Ok, I'll try and elaborate... Imagine I have a table, which has column "field heading", "area". So the datasets are like this: 1.3.9...
Yesterday at 7:15 PM
K
Kingz
replied to the thread
Solved
Dynamic Insert statement
.
Yes, I was getting an error 9, which is basically saying I'm out of the range.. Let me modify the question, to make it more concrete...I...
Yesterday at 2:04 PM
K
Kingz
posted the thread
Solved
Dynamic Insert statement
in
Modules & VBA
.
I have a function whereby I am trying to create an insert into statement by saving the column names from a select and using that output...
Yesterday at 1:12 PM
K
Kingz
reacted to
Gasman's post
in the thread
Solved
Search comboBox on a bounded form
with
Like
.
I believe your combo needs to be unbound, else you will be changing data in that particular record. So you need a Search combo added.
May 15, 2024
K
Kingz
reacted to
Pat Hartman's post
in the thread
Solved
Save button on bounded Form
with
Like
.
So, did you use the BeforeUpdate event correctly to allow/stop the record from being saved? I think in one of your earlier posts, you...
May 15, 2024
K
Kingz
posted the thread
Solved
Search comboBox on a bounded form
in
Modules & VBA
.
Hi guys, I have a form with a recordsource SELECT * FROM TABLE_A WHERE BRANCHES ='OPEN' This form has several textfields and combo...
May 15, 2024
K
Kingz
reacted to
Pat Hartman's post
in the thread
Solved
Save button on bounded Form
with
Like
.
@Kingz Did you ever try using the form's BeforeUpdate event? You might want to read #25 again and try to understand what I am telling...
May 15, 2024
K
Kingz
replied to the thread
Solved
Save button on bounded Form
.
No, it will always be two people.. It's called the four eyes principle..I made the two columns extra for that. What I'm asking is for a...
Apr 29, 2024
K
Kingz
replied to the thread
Dynamic default of text field possible?
.
I tried it on form_current() but it didn't work.. Actually instead of looking in the table I wanted it to just take what was in the...
Apr 29, 2024
K
Kingz
posted the thread
Dynamic default of text field possible?
in
Modules & VBA
.
A user of my form would like a default date appearing in a text field of the form. This default is to be the last date used on that...
Apr 29, 2024
K
Kingz
replied to the thread
Solved
Save button on bounded Form
.
Well, to answer your question, with regards to the approval. I have two columns "1_Val" and "2_Val". When the 1st person edits...
Apr 29, 2024
K
Kingz
reacted to
Pat Hartman's post
in the thread
Solved
Save button on bounded Form
with
Like
.
@Kingz You say you are a beginner. then as the others have said, let Access be Access. You are using a RAD (Rapid Application...
Apr 29, 2024
K
Kingz
replied to the thread
Solved
Save button on bounded Form
.
And when in practice - please tell me if this makes sense - I will have the two tables in a centralised Access DB alone( called it...
Apr 23, 2024
K
Kingz
replied to the thread
Solved
Save button on bounded Form
.
Oh, relationship window,with regards to foreign keys and connections of tables? No there's none of that to consider
Apr 23, 2024
K
Kingz
replied to the thread
Solved
Save button on bounded Form
.
What's a relationship window? It's two tables...Both have the two columns in it. The first table is to make sure the dataset is only...
Apr 23, 2024
Home
Members
Top
Bottom