i have an access database on a server. it is split up into front end and back end. people are accessing the database's front end using a shortcut from their desktop computers. i know for a fact that multiple people are using it at the same time. for some reason, when i created a shortcut on my computer to access the front end of this ...
I have 2 tables. The first one has the columns name, value and offset. The second one has the columns result and calculation. I want to know if there is a way to write a query in access where I would select name, value, result and calculation on the criteria the selected result would be between the selected value+(offset/2000) and value-...
does anyone know how to add a TEXTBOX onto a word 2007 document. i need to gather user input and after the form is filled out, the data will be added into an access database thank you! ...
i have a file like this: strPath = "S:\HR\Forms\forms_database.accdb" i am connecting to it through an WORD adodb.connection should my database be a different extension ? MDB or something? i am getting this error when it tries to connect: unrecognized database format 's:...............accdb' what's going on here? here's the enti...
what is the difference between these two extensions? i need to write to an access database from a WORD file using an ADODB connection when i create a new access database it gives me the option to make only an ACCDB file and for some reason i cannot make an MDB file can someone please help me create an MDB file so that i am able to ma...
anyone have examples of sophisticated WORD 2007 forms that posts to access DB using ADODB connection? ...
I am trying to output an XML file with an Ole Object from an ACCESS 2007 Database. The receiver is very specific about the format of the XML file. In order to meet the requirements I am using MS scripting. However, when I run the script I get an incorrect procedure error. It is being caused by trying to add the Ole Object because whe...
Is it possible to have a SQL statement in Microsoft Access that can disable the unicode compression property on a column ? Something in the lines of : ALTER TABLE MyTable ALTER COLUMN MyColumn DISABLE UNICODE COMPRESSION ...
I'm in the process of normalizing a few tables and I've added a surrogate primary key to a table called Exams which holds exam titles. Previously, the child tables would just use the entire name of the exam as the FK entry. Now that I've added a autonumbered field to the table, I want to update the entries that use it such as the tabl...
In Microsoft Access , is it possible somehow to get a list (via a SQL query ) of all columns that have UNICODE compression enabled ? Maybe by executing a query on some Microsoft Access system table ? Any ideas ? ...
So I am trying to use a button click to open the next form (in my form flow), and pass the ID to the next form using openArgs: docmd.openform "NextForm",,,,,, MainID docmd.close acform, "CurrentForm", acSaveYes the second form will not open....i have never run into this problem with a docmd.openform in a sub before. however, this is m...
hello. i am trying to display the values of a stored query i have created in an access database. the stored query uses a number of other stored queries to calculate the results. Everything was working fine until i used the dconcat function of access in order to concatenate the values coming from some records. The strange part is that ac...
So I pass the ID value from one form to the next using Docmd.OpenForm "SecondForm",,,,,, MainID Docmd.Close AcForm, "FirstForm", acSaveYes and then I check the value on the Second Form's load event: MainID = val(Me.OpenArgs) and when I debug and step through I hover over this and can see it contains a value Then I have a button cl...
I am using rs.update to change some values. something like rs("SomeField") = frmSomeOptionGroup.value where I want the actual option value to be stored in the table. however this just simply seems to return true or false values to the table instead of 0-2.... so what should I do to make this concept work? thanks justin ...
Hi, I have created an .mdb file programatically from another .mdb file using VBScript. It creates a table in the second .mdb file and populates data. Everything works fine and data is populated correctly. This is done using JET 4.0 driver. The issue is that when I try to open the .mdb file using Access 2007, it tries to repair the fil...
Hi, I'm looking for example code on how to connect to a ODBC database using Fujitsu COBOL. I couldn't find any documentation on their site which was useful to me :-S. Many thanks, Yvan ...
I have a Posts table and PostComments table of a blog system. I want to count and sort the posts by comment count but my query won't work.: SELECT Posts.PostID, Posts.DateCreated, Posts.Title, Posts.Description, Posts.Hits, (SELECT Count(CommentID) FROM PostComments WHERE PostComments.PostID=Posts.PostID AND PostComments.IsApproved=Tru...
I have a table that holds several hundred records but I with a special property. I only want the user to be able to select that property 50 times though. How can I set a limit and return an error when the limit is reached? ...
Hi All, I want to use Microsoft Enterprise library Data Application Block for MS Access database (OLEDB provider) I want parameter based INSERT functionality with enterprise library (Just like we do for SQL provider with parameter based code like - database.params.Add("@EmpName", this.EmpName); I want the same thing for MS Access data...
I'm having some trouble getting my DataSet to work. I have a MDB-Database in the background and created a DataSet out of it. Now I created a new method that lets me create a new user in the table. But when I call it, nothing happens. No exceptions, no errors and I even get "1" returned as number of affected rows. But when I look in the...