Search results for query: *

Hello, I need help: I have 2 forms, the first one called frmMain, and the second one frmFilesList. frmMain is the main form and I have a menu option to select that opens the second form. On the second form I have a datagrid that is supposed to display a list of records I have in a recordset...

Hello, I have a application that I have successfully converted to use data on a sql server. I have no linked tables or DSN's for this application. I built the system using access 2003. My problem is I have alot of access 2000 boxes that it needs to run on and it errors on the connection...

Hello, I am converting a standard access application that is setup with the data and application split. I have problems with the speed of the application due to the slower data link between buildings. I have been successful in converting the data to MS sql server 2000, with all data access...

Hello, I have form1 which has a subform (form2). in form2 code for form_open I am setting the recordset to a sql query that attaches to a sql server. When I open form1, form2 loads as the sub form great and I have data. what i can not find how to do is update or change the recordset of...

i can input and output to a text file as long as the file is in the same directory as the c++ program. but i cant figure out how to input output to a file in a different directory i.e. I:\c++projects any thoughts. thanks

Hello, I hope someone can give me some help. I have coded a database and has been operational for about a year. I have been adding another section to the database and I am currently getting an error on code on code that has been working. The following is the line of code that is causing the...

Hello, I have a question on how to tell which form called another form. On form 1 when I select option "A", I open form 2 for data input. Once form 2 opens I would like to know how to figure out that form 1 was the form I was in before opening form 2. Form 2 is a multi purpose...

Hello, I would like to know if there is a way to keep some table in the local access file when you splitt the database. And How to add tables to an already created split data file. I have a shared DB that has 25 users on a network. I have a few tables that I have located in the local access...

I would like to know if you can place a tab control pages inside one of the tab pages of another tab control page? Thanks, Dave

Hello, I have designed a query (qry2) in query design that uses both a table and another predefined query (qry1) which was also designed in query view. Problem: I am tring to convert the query into code. I do not know how to reference the predefined query object (qry1) in my final query...

I have a few combo boxes on some forms that I wish to validate so users can not type in some bogus data. I setup the validation rule property on the combo box to =dlookup function which works great. My problem is I really need to allow for blank or null inputs. Once you enter a valid value...

I would like to know if there is a way to compare the contents of records to decide if the records are indentical. I have anywhere from 2 to 10 records I need to compare and report which fields are different. I will always have one record as my base line to compare the rest of the records to...

Hello, I would like to know how to fill a list box using an array instead of a table or query. All help files and books are very vague about this and only say that you use a function and place the name of your function into the data type in the list box porperties. Thanks, Dave

In testing my current project, one of the processes deletes all records from one table then goes through a process to repopulate that table with the most current information. Through the testing process I have run this process many times and I just noticed that the size of the database has...

Hi, I have a process that runs, I am tring to log all problems I encounter to better resolve. I am writing alot of info for each error. I use on_error and when I am done I resume Label: I had this info displayed via debug.print but it appears that I am overloading and losing the first items...

I have several combe boxes on a form, all unbound with lookup coming from another table containing just the options for that input. these combo boxes go in order 1, then 2, then 3. I would llike to limit the chooses in comdo box 2 to only the ones available for the selection option in combo...

Hello, I would like to execute the contents of a variable within my code. simple example is: counter= 10 newvar = "counter + 5" how do I get newvar to equal 15. thanks, dave

I am building a database by building basically an array to hold all my values before I write a record to the table. This is done because the values come from querys and calculations from around 75 different source tables. heres my problem; I need to over ride the value of one of the variables...