Recent content by pjStyle

Thanks for the help dcx693!! This was exactly what I was looking for!

I'm trying to build a dynamic sql query using VBA, thing is, i don't know how to assign a certain sql script to a Query in the database from within VBA. Any help would be appriciated! Ted de Vries

Sorry for the late reply, but I really want to thank you for your reply! It was really helpful :D

I have a question. I want to able to search for a record in a form using VBA. I've constructed the following while loop: Sub SelectCurrentBeg(dBegid As Double) Dim temp As Double temp = Begid.Value While temp <> dBegid DoCmd.GoToRecord , , acNext temp = Begid.Value Wend End Sub Now the...

I have a question. I want to able to search for a record in a form using VBA. I've constructed the following while loop: Sub SelectCurrentBeg(dBegid As Double) Dim temp As Double temp = Begid.Value While temp <> dBegid DoCmd.GoToRecord , , acNext temp = Begid.Value Wend End...

:rolleyes: I'm so stupid

Rowselect with Listbox?? I'm creating a system where a list of volunteers must be created. Three of these volunteers must be easily selectable with the press of a single button. I have created a listbox with all the volunteers in it. Now the thing is, you can't select a whole row of text in the...

Thank you for your reply! I have absolutely no experience with Access so i accidentely overlooked the listbox :) I'm used to programming in Borland delphi, where i can just retrieve information about the currently selected record in a Gridview. Thanks again for your reply, Ted de Vries

To shed some light into the situation i'm trying to create, i've attached a screenshot.

Hi, I have a question, i can't seem to find a suitable control to use on a form i'm making for a project. First let me tell what the form is supposed to do. At the right side of the screen there's supposed to appear a list with volunteers sorted by grade ( which are calculated in the system )...

It's not the same data :) One table lists the name, address, etc. and table B lists all qualifications of a certain candidate from Tabla A. I want to divide the data over two tables because the total number of fields of the two tables is like 50+

Newbie question :) I have a very simple question. I'm working on a school project now, but i don't have too much experience in access. The thing is, i have a Table A and a Table B. Now when i insert a record into table a, at the same time a record must be inserted into Table B with the same...

I have a question for school. We are doing a project for a company, whe're rebuilding they're current database. What my problem is at the moment, is that i have one form which i have a query attached to as datasouce. The selecting of the records works just fine, but now i want to add new...