Hello, I'm looking for a VBA command that can tell me the value of this text box "Zon1" in the form "for1" and copy it into the field "ch1" of the table "tabl1" I've been searching for two hours and I can't find anything on this line of code. Anyway, thank you in advance.

[ACCESS]text box value = field value : CCM

Answer 1 / 7

LatelyGeek Posted messages 1774 Registration date Status Member Last intervention 550

Is the For1 form based on Table1? If so, it's simple, just say
Me!Champ1.Value = Me!Zon1.Value

Otherwise, it's more complicated, because you also need to tell Access not only in which field but especially in which record this value should be saved. Unless it's about adding a record?

--
Why complicate life by making things simple when it's so easy to make them complicated?

schub

Hello,

From reading your responses in the forum, I see that you are well-versed in Access. I have a small problem with an application I'm starting to set up. I want to track the presence of participants using an options group (Present, Excused, Absent). This works well on a form built for example on table 230809 corresponding to the meeting date, but for subsequent ones, I don't want to recreate the form. Instead, I would like to select from a dropdown list the table corresponding to the meeting date and then enter my attendance on that table using the options group. I'm not sure how to select a table so that the form works on the one chosen. Additionally, I would also like to display the minutes in PDF format based on a selection triggered by a button.

I apologize for imposing like this, but if you could provide me with some solutions, I would be very grateful.

Thank you in advance

Schub

Answer 2 / 7

LatelyGeek Posted messages 1774 Registration date Status Member Last intervention 550

Oh dear, I'm not Ms. Cleo, you need to tell me more!!!

What’s in the form, which tables, which fields, what are the text areas called, which field needs to be filled out, and all that!!!

Normally it shouldn't be too complicated to solve....
--
Why make life complicated by keeping it simple, when it's so easy to make it complicated?

Gooze

Sorry,

actually I want to create a call entry database.
I have a form that presents all my installations (called BASE_INSTALLATIONS).
Through a form (called Formulaire_MAIN_COURANTE), I want to record the call and the issue encountered.

To find out which installation it is, I made a query on my BASE_INSTALLATIONS table that I display as a sub-form in my form.

By clicking on the row of my sub-form, I pass the values (N°INSTAL, NOM_CLIENT, ADRESSE...)
to text boxes in my form (called Choix_N°INSTAL, Choix_NOM_CLIENT, Choix_ADRESSE...)
I want to save each call (so the values from each text box) in a table called MAIN_COURANTE with several fields (for example N°INSTAL, NOM_CLIENT).

I have also created several text boxes for call information (Saisie_PANNE, Saisie_NOM_CONTACT...) that I also want to send to the table, as well as checkboxes and a radio group to indicate the name of the person who took the call.

So to summarize, I want to be able to send the content of all the text boxes from my form to a new row in my MAIN_COURANTE table (via a button).

Sorry for the density, but I'm a bit lost.

Thank you very much in advance!!!

sarrachfm

I want to create a text that changes its value every 3 seconds when clicking a button only once.
Please help me, I'm preparing my final project and I've never used VB6 before, thank you thank you! :))

Answer 3 / 7

Sebimy Posted messages 6 Status Member 1

Hi

I tried it and it works perfectly, thank you very much.

Gooze

Hello,

I have the same problem.
I want to send the value of my text box to the field in my table when I click a button.

By entering this code in the "on click" event, I get an error that appears:
"Runtime error 2448 Cannot assign a value to this object"

What should I do?
(I am a beginner in VB)

Thank you in advance

Answer 4 / 7

LatelyGeek Posted messages 1774 Registration date Status Member Last intervention 550

I am going to start over.

Is it possible for an INSTALL N° to correspond to several clients, each having multiple addresses?

On the other hand, I'm afraid you are miles away from the right direction... What do you mean by "creating text boxes that should return values to the table?"

Do you know that if your form is based on a table, whatever you enter in it will automatically be saved in that table?
--
Why complicate things to keep it simple when it's so easy to make it complicated?

Gooze

No, an INSTALL number can only correspond to a single installation.

In my form, I created text areas (for example, CUSTOMER NUMBER: and I have a text area where I enter the CUSTOMER NUMBER...) where the data (INSTALL NUMBER, CUSTOMER NAME, ADDRESS, ...) is displayed, and I want to retrieve the content of these text areas.

But during my call, I want to enter either the INSTALL NUMBER or search for the customer by their name, address... (so I display a sub-form to facilitate selection).

I have already tried to create a form from the table, but what I enter in the form does not get saved in the table. But you can surely explain it to me :).
Because originally my MAIN_CURRENT table is empty. And I want to fill it with all the copies of the text area contents from the form, and basically I want to select a line of installation via my form (with all the necessary information such as CUSTOMER NAME, CUSTOMER NUMBER...) and copy it into my MAIN_CURRENT table (I created a column displaying the current date and time to timestamp my calls).

But when I saw Sebimy's problem, it was exactly the solution to my issue, just copying the text area values from my form into my table.

Answer 5 / 7

LatelyGeek Posted messages 1774 Registration date Status Member Last intervention 550

No, you're thinking backwards.

Your form should be based on the MAIN_COURANTE table.

The N°Install field is from that table.

However, you can add an independent text area in the form of a list box, to select a client and then an installation from their list, but the other fields must be from the table. The record is created automatically. You're creating an incredibly complicated system, and that's why you're facing issues.

Access one simple mode of operation.
It's when we try to bypass it that things go wrong, and that's what you're doing.

Try to adopt Access's logic instead of trying to force it to take yours; it will save you a lot of hair-pulling...
--
Why complicate life by trying to keep it simple when it's so simple to make it complicated?

Gooze

Well, this time the table recording from the form worked.

But I would like that every time I fill out my form, the recording is done on a new line (because when I open my form, the first line of my table appears)

How to do that?

Answer 6 / 7

LatelyGeek Posted messages 1774 Registration date Status Member Last intervention 550

Oh yes, you don’t know anything about Access at all...

You need to access a new record, otherwise you'll overwrite the first one.

Add a button using the wizard in design mode.
--
Why make life complicated by doing simple things when it's so easy to make things complicated?

Gooze

Yes, I'm discovering Access (even though I've made quite a bit of progress).
Thank you for your details, my form is successfully saving in my table.

Quick question: when I enter a row, save it, and display my MAIN_CURRENT table.
But the table shows the latest records, and I have to refresh the table to see the new one.
How can I integrate the table refresh into my save button?
I've tried several macros, but I can't manage it.

Answer 7 / 7

LatelyGeek Posted messages 1774 Registration date Status Member Last intervention 550

Have you tried Refresh (in macro) or DoCmd.Requery (in VB)?
--
Why make things complicated when it's so easy to keep it simple?

Gooze

Yes, but it doesn't work.

I managed to do something that suits me. Even though I may have made things a bit complicated for myself :)

In any case, thank you very much for your help.

[ACCESS]text box value = field value

7 answers

Iptv iron pro cut off

Fraudsters are now using your real iban in their phishing emails to rob you.

List numbering style

Pdf file

Set up a network

Unable to add an email account in outlook.

Sony wh-1000xm5 not turning on after getting wet

Google earth pro route not working at all

Texture issues in enshrouded

Usb port → usb serial