Hi there,
I have a question about forms in MS Access..
Is it possible in any way at all, to add info in 2 textfields and save it as 1 record.
Detail:
I have a record with 3 fields. "Patchnumme r" "Patchkast" and "Ruimte"
"Patchnumme r" (XX-0) XX stands for A-Z and 0 stands for 1-24
"Patchkast" (XX0) XX stands for A-Z and...
f3dde
Last Activity: Feb 18 '08, 01:29 PM
Joined: Nov 30 '06
Location:
-
2 textfields as 1 record
-
Thanks! Found it.. Got it working now to..
Regards
S... -
I'm not exactly a "pro", and since my foreign language isn't English it's also a bit harder, but could you please explain me what you mean by this? Because I've been looking for this in Access, but can't seem to find this anywhere. Thanks for your help.
Kind Regards,
S...Leave a comment:
-
Editing listbox value
Hi there,,
I am currently working on an Access ' 03 database to store all computers in the company, and to keep track of stuff that has been done with those computers (new installations / replacing components etc.)
I have all the computers in a table called: "PCs"
All the changes for the computers are stored in "Reparaties "
All the computers have an identical name. "004-01"... -
Combolists
Hi there..
Before asking my question I will describe the environment I'm in.
In Access 2003 I've made several tables with different kinds of things. With queries I've combined several of those things. Now in the Access file there is the possibility to get a dropdown box in a record in which you see 2 or more different recordsources.
Now I'm trying to do the same thing in VB 6, with those combo dropdown/list... -
Got it to work allready. Thanks anywaysLeave a comment:
-
@Tifoso, I can't get that to work, keeps giving me some kind of error.. So I pretty much tossed away all of the codes I used and trying to start overnew, hope it helps.
@jeffbroodwar, I know that part, the code for deleting is the one I don't know..
Thanks for the help so farLeave a comment:
-
Running ACCESS query in VB
Hi there
I am trying to run a Delete query in VB made in Access. My goal is to press a Command button in my VB Form, get a msgbox to ask for confirmation and then delete the records that should be deleted.
The SQL code for this query in Acces is:
I have a completely empty form in VB, and well.....Code:DELETE Uitlenen.[Terug gebracht] FROM Uitlenen WHERE (((Uitlenen.[Terug gebracht])=True));
-
Allright, since no one seems to know the answer to my question I will state it in a different way.
In my Access database I have several forms. I figured out how to make a VB form from all these forms, but now I am trying to get all the forms I have in Access into 1 big form in VB. Is there a way this can be done.
I'm trying to make 1 file, which contains a menu in which you can pick the other forms. So my goal is to...Leave a comment:
-
Combining several forms
Hiya,
I am working on something that has several VB forms. Now I like to make all those forms into 1 form. Is it possible to make some sort of menu, just like in MS Access to have multiple forms into 1 big file. If this is possible, would you mind explaining me?
Thanks in advance
~F3dde -
Alright. Since I've had a critical error which made me delete the whole thing I had to start over again, and because I can't find a way to edit my post I made this new reply.
I had to edit my code, because I was unable to get it to work again using the code I posted earlier.
Currently my code looks like the following:
...Code:Option Explicit Private Sub Adodc1_WillMove(ByVal adReason As ADODB.EventReasonEnum,
Leave a comment:
-
...Code:Option Explicit Private Sub Adodc1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset) Adodc1.Caption = Adodc1.Recordset.AbsolutePosition & " van " & Adodc1.Recordset.RecordCount End Sub Private Sub Form_Load() Adodc1.Caption = Adodc1.Recordset.AbsolutePosition & " van
Leave a comment:
-
I am able to see my database trough the ADODC. It looks just like the form in Access now. I just want to be able to edit it in the VB form now, which I am not able to do yet. In other words. I'm trying to find out how to code the Command-buttons in order to make a new record. I hope this makes it more clear to you....Leave a comment:
-
Making new records with VB
Hi there,
currently I am trying to get some basic experience with VB6
I was able to make a connection with MS Access already, so I made a form and made use of a ADO DC. Now I can see trough all of the records from that Table in the Database. Now am I trying to make it possible, to create new records using the Form in VB. So I made a Command button, tried some stuff and got stuck.. I have absolutely no clue on how to make a new... -
I've tried what you said, but when running the query (both select and delete) I'm getting a popup telling me I have Incorrect data input.
I've called the record "Terug gebracht (Ja / Nee)" This is a checkbox.
It should be Ja when checked, Nee when it's not checked.
So the "Ja" in the criteria doesn't work.
Any other idea's?Leave a comment:
-
Delete Query
Hi guys, I've got a (for you) pretty simple question.
I am making an Access database (2003) for school. It contains information about stuff you can hire here.
In the table which I use to register all the stuff given out I have a checkbox. This is checked when the loaned stuff is returned.
The query looks as following:
Field: "Terug gebracht? (Ja / Nee)"
Table: "Uitlenen"... -
Thanks a lot for your help. Finally got it to work.Leave a comment:
-
Okay, I know you may find me an idiot, but for some reason I can't get this to work.
Would you mind explaining it a bit more detailed?
ThanksLeave a comment:
-
Deleting records with a date that passed.
Hi there,
since this is my very first post I hope I did it right.. Read the guidelines, so I doubt I do to much wrong.
I am working in Acces 2000 and I have to make a database for a "Rent A Car" company.
The company wants me to make it able to see what cars are rented and which are not, and so make sure that a car won't be rented twice. There is a record for a start date and with an end date. When the...
No activity results to display
Leave a comment: