Search results

I need to write some code that will call itself. Is this allowed in Access. Basically traversing a tree structure and need to go down each branch to the bottom.

I have a few tables, I am running Access with multiple people accessing at the same time from different Workstations. What I need to do if execute the command: rec_dao.AddNew Then be able to find out the value of rec_dao.ID (Which is an AutoNum field) There are no unique fields other...

It is possible to get an Access WEB front end to run on a Linux server? The back-end database will be PostgreSQL. If it is not possible to get access to run on Linux, can you recommend some other 'Access' like front-ends that can be deployed on Apache/Tomcat on a Linux server.

OK I thought this would be easy, go figure it isn't. I need to change a label of a VBA form. There are a few check boxes for work to be done a big label box Named 'CompMsg' (this is what I want to change). and a button to get the whole batch running..... When I press the button the called...

I have some VBA code that opens a form gets some user information from the user (this is all working great) and returns to VBA. Here is where I am having problems! I need to make sure VBA is looking at the most current data available, NOT the data when VBA started. On the query on the...

I have a little code here. If I include the code with the ORDER BY clause I crash with a 3095 error. If I comment the ORDER BY out, and execute the second select command instead everything works. Question, what am I missing. I have tried braces, bracket, parenthesizes you name it nothing...

I have a large loop running, inside this loop, the program needs to stop for operator intervention. (See code below) Once the user and adjusted the data the loop continues on. At least that is how I need it to work. What is happening now is the program completes until the end of the file it...

I have to run through a large (read several hundred thousand records) import file. What I was trying to do is just show the user a progress bar, so they know something is happening, while they wait. I am using this code: Set rs_datain = DBEngine(0)(0).OpenRecordset(strsqlin)...

I am trying to do something like this: IF EXISTS (SELECT 1 FROM Table1 WHERE Column1 = 1) BEGIN -- UPDATE QUERY END ELSE BEGIN -- INSERT QUERY END ENDIF Does this work in Access 2013 VBA? What I need to do is check to see if a hashcode already exists in the database. If it does...

I would like to find a way to execute SQL code on a remote BE server. Most of the code is going to be simple SQL schema maintenance like adding tables, or columns. There might be some creation of views or triggers. The reason for this is simple. A client gets a new version of the software...

What I would like to do is code my VBA so that it is as installation independent as possible. Right now the FE is Access 2013, and I would like the BE to be any one of Access 2013, MySQL, Postgresql, SQLServer, Oracle, DB2. Is there a way I can keep 99% of the installation specific code in...

I have a form, sort of a menu, with a couple controls to set some parameters in a little database. On this form I currently have a sub-form control. What I need to do, is depending on which of several control buttons on the main form is pressed, the actual sub-form changes to be what the...

I have a sub-form/form created. When I open it as a form I get to see all my fields (with data missing) When this form is opened as a sub-form all the fields are missing The other odd thing is the query for the sub-form as 2 records in it, but these records no longer show up in either...

I have a sub-form that will have a random number of records depending on the calling form. It is important that the user know that they have looked at all the records. What I want to do, is pretty much copy what is down in the navigation part of a the sub-form "Record ## of 88" in the header...

Here is a fun one, that comes out of an end user request: What the user would like is a check box, or something, that will allow them to turn on the ability to edit a form. The normal state of this box would be false (ie Read Only). The reason for this is pretty simple, they are in the...

What I am looking at doing is creating a black box function, that will be passed a memo field, open up a form so the user can edit this field in a pop-up box, then pass back the edits to the calling form. Now the question is, is this even possible? If so how do I assign the run-tune variable...

I have what was supposed to be a table sub-form in Access 2010. Just a list of short records relating to the parent record. For some reason this has switched to a form type view, ie showing only one record at a time, not the list of records. Question is how did I mess this up? How to I put...

I have a form with several fields and a subform. What I am trying to do is write some VBA code so that when any one of the first three fields is changed: A) VBA code will update a field of one of the open tables, B) Access will re-query the forms data source query, C) Access will refresh...

I have a query, really simple one, 4 fields from a table, and one calculated field based on the values of the other 4 fields. Problem is, when I browse the query I am unable to change the fields, but if I go into the table itself I can edit no problem. What is causing this, and more...

What I am trying to do seems simple, but the exact method eludes me. What I need is when (unique for each user/session) an Access accdb is opened, three global variables are created and default values are set. These variables need to be active throughout the users session and keep any user...