[microsoft:access] Forum Topics

I use MS Access database and I want to create a simple backup system, but I have not idea how to create it. I tried with copy paste on the database but I got error because my database is being used by my application... I also tried to disconnect the …

Hi, I've created a query that inner joins 4 tables. The tables have a common field CPname and CoverType. The query works and results are correct. However, when I use this query as my record source for a report, I came up with this error: "The specified field 'TblCover.CoverType' could …

hello every one, i m trying to insert data from jsp page to database using sql insert query. every thing is working fine but when i m using autonumber in database(Ms Access) it is showing error. so please help me how to do it??/

Hi, i have a group box with 2 radio buttons; failure and success. I need to have the text (either failure or success) saved in the access 2007 database instead of values (1 or 2). The same is also happening with the combo boxes. Here's the code am using: (i …

I has a problem with MS Access queries: In SQL, if I want to include arabic word in the query where part, Simply I add '[COLOR="Red"]N[/COLOR]' before the arabic word. The question is what represents this character in MS Access query. Thanks in advance.

i want to ask some question ??? [code] Dim conConnection As New ADODB.Connection Dim cmdCommand As New ADODB.Command Dim rstRecordSet As New ADODB.Recordset conConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\Documents\Visual Studio 2008\Projects\trial database\Microsoft Office Access 2007 Database.accdb"" conConnection.CursorLocation = ADODB.CursorLocationEnum.adUseClient conConnection.Open()[/code] im using visual studio 2008 ,i want to access to mirosoft access …

Hello all, I have sql server 2005 and sql server 2000 installed on my PC. Our server only has sql server 2000. In my test environment (local pc) i need to configure my database (and/or) web.config to use sql server 2000 instead of 2005 for the profile provider. I have …

All, Have a frustrating report problem. Have code of:[code]Function RAmount() HrsAmt = DLookup("trp_ham", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) MilAmt = DLookup("trp_mam", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) RAmount = HrsAmt + MilAmt End Function Function RCount() RCount = DCount("trp_id", "qryTIMshtS") End Function Function RTotal() HrsTot = DSum("trp_ham", "qryTIMshtS") MilTot = DSum("trp_mam", "qryTIMshtS") RTotal …

Hi ,im new to vb...mine 1 is visual studio 2008 ,hope anyone can help me TT my problem is.. i got two form .. 1 is the login form 1 is the register form i need to code ,when the user is register and types in the detail..it will automatiic …

Hey Guys, Some of you know (Tim) that I'm working on a Professional Development and Training Database. I'm about to demo it to HR but I would like to add a feature: If a course is "Mandatory for all employees?" is checked in tblCourse, then check "Mandatory for Employee?" field …

Hi all, What is the best method to move data from an access database into sql server database with different table and field names? If possible could you give me an example? Thank you so much!

[COLOR="Red"]I connected a access database by usin codes, But when i add new data the data doesn't display in same time. it need to restart the programme. can I solve this?[/COLOR]:)

Hi guys, im trying to develop a library system.. i actually don't know how to implement/create a code on filtering a certain search for a certain book by using keywords.. any code snippets out there?

Hi, I'm using Visual Basic Express 2008 (VB.NEt). I've created a project which connect to a Microsoft Access Database (OLEDB) & displays the records using textboxes in the windows app. I need to add a button which exports the database to a fixed length text file. Does anyone know the …

I am trying to write a function that will perform different calculations based on a Log Code. The function is returning an error of undefined external name. I think that I need to open a recordset, but I do not know how to do this. Any help would be great. …

Hi I want to show a crystal report in my windows application.In my Access DataBase I have a column called Payment type and its type is number.(ie data in that column is stored as 0 or 1).If payment type is 0 I want to show it as a string called …

Hi Friends, how can i change the color of a cell when Datagrid cell is cliked and also this color should be saved in Access database on the same cell. Thx - singoi

Hi all, I want to know how i can decrement the value of quantity in stock in my data base. This would be based on how times an item is purchased. So every time an item is clicked, i want to show the quantity has decreased in the database. I …

can someone help me, i want to use c++ and MS-Access as the database so when i use the SQL component instead of the Table i get an error

hi all i got problem reading multiple table from ms access using jdbc. i read two table from one class but i got 12 table to read. so how can i do dat? any help will be great thank you

Hi Guys, I have a client with an SBS 2003 server. They use a Microsoft Access 2007 database which is split in two. a front end (Which includes all the forms) and each of the client PC's has a copy of the frontend on their PC's. And a backend (which …

hi! i'm new here. i have problem with my database. i asked my friend to key in data. then, i want to combine all data together in ms access at my computer. when i run the system the run time error "13" type mismatch appeared. i don't know what this …

hi i just installed windows 7 version and i am getting this error while running my vb project [code] The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. [/code]

Hi, Having troubles with the conversion of date in a textbox i think.... currently txtDate.text has the date format of dd/mm/yyyy and im trying to grab data from the database that is equal to that date and put it in a listview. Problem Im haivng is the conversion from MM/dd/yyyy …

Sup guys? i need help finding tuts and articles on using Jet for manipulating a MS Access database file in VB2008. Everywhere i look, i only see stuff about using SQL server. I just want to code a program to manipulate MS Access Database files. I found 1 link, it …

All, Having a problem with process flow while printing. I have a process that: 1. Pulls and Prints a summary sheet grouped by client (report 1), 2. Pulls and Prints a seperator page with Client Name (report 2), 3. Pulls and Prints the Client tickets for the Client (report 3) …

All, All the help & HOWTOs say you can get subtotal from groupings and grand totals with the use of: =sum([fieldname]) and I have used this in the past, but current report is erroring by giving the popup, asking for value entry on each of these I placed in the …

Hello Everyone, I have a large database where I'm using Dlookup to find the next record in the database. I need to find the next record providing it meets a specific criteria. If it doesn't meet the criteria then I need to look at the next record to see if …

Hi In my VB program, I am going through a database, adding each row/record to a listview. One of these fields is a date. For each row/record, I want to get the difference in days between that date, and the corresponding date in the next row/record. Thanks Robert

i did not see anyting for microsoft access was wondering if some one could help me on a question i have on it?

Good Day, I am using an Ms Access Database to design a StockTracker applicaton. The application is used to check the stocks of users. Firstly I need to sign on as an administrator and then be able to add users and their stocks to the database. I have created the …

Hi, For Filemaker 9 I have a pretty big problem here. I have an account layout a contact layout and a Comments layout. The ID for the account layout is attached to the ID for my contacts layout. If account ID = 12 and new contact is clicked Contact ID …

Here is what I got and maybe this will help. In example 1 you are on the company page which shows that company and some information that is needed for this company. The bar that runs about in the middle accross that will have links for CONTACTS - JOBS - …

i need code for saving a file in access database using C#

Hey, again I grace you guys with another question. I've run into another speed bump - REPORTING! I didn't create the database - just simply adapting it to the needs. It was created externally. Since Access allows only a certain number of fields per report, I divided the reports into …

Hi all. Currently I am (trying to) writing code to read information from MS Access using win32com. I was wondering if anyone could help me with some code to do this. I am completely stuck! I have used win32 before for excel, but I’ve never used access before and the …

Hi, I am trying to recover the data from my address book (Microsoft Outlook). The data is on a hard drive from an old computer (Dell Inspiron 4000 with Windows 2000 Pro) that would not boot up because of an explorer.exe problem. However I can access these files using the …

So i'm used to using mysql, but i'm on a project right now that uses an access database, and I'm looking for a way to replace LIMIT. I googled around and found the information on TOP, but it doesnt totally replace the functionality. For example if a user were to …

Man, I hate having to get you guys to hold my hand through all this, but I've run into another problem. I have my ODBC connecting to a MS access database. This is all coded into a library that gets injected into a video game, and then macro commands call …

recently i m working on a business software in vb6 and ms access. How can i get registration no for this. It can be generated only through machine id (HDD no) 10 digit in alpha numaric and numaric combination and key no. (any no in any combination). There also a …

I have an access database that I wish to password protect, If i am only using access that is simple. I have a program in VB6 that reads and writes to this database I need a little help in setting up the Access data object in VB6 any ideas.

Hey guys im really new in Microsoft Access my school give a assignment on Library management system in access only. and now im stuck . 1.Condition is Fine - .10p fine per book after 10 days. i could not set this condition on my database.i tried a lot but still …

Hi! I would like to do something like this: [url]http://www.adp-gmbh.ch/ora/explainplan.html[/url] with an .mdb file. Thanks!

I have a query which has a prompt when you insert the year a graph on a report displays.My problem is that when I enter the date the same prompt appears two times after I inserted the year. Also when I what to print the graph it also prompts me …

I'm working with Access 2000. I have a form with data from a table, tblParts, and a list box with data from another table, tblRDM_Numbers. The two tables have a one-many relationship with tblParts.name as a foreign key for tblRDM_Numbers. I would like the list box to update every time …

I am working on a vb app and am getting this error when calling a form (frmCaseList) from another form(LoginForm). the frmCaseList wasat one time in a different solution where it worked fine (it was the startup form). frmCaseList is also inside a namespace. If I commentout the [icode].show()[/icode] line …

I want to draw a graph in vb6 thta will take data from the database (here it is MS ACCESS) .The databse has a table with 2 columns,How to draw the 2d graph dynamically, I am connecting the databse and vb 6 but an error is occuring Please tell me …

Hi I want to know how can I make my database that the user can add a field to a table from a form or sth? thanks

I made a queiry. but every data show in this queiry double. I mean every data show two time in this queiry. why this problem occured. any body help me please.

I have tried Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Try Me.BindingContext(DataSet11, "wtab").EndCurrentEdit() Me.OleDbDataAdapter1.Update(DataSet11) end sub AND ASLO TRIED Dim Row As DataRow Row = Me.DataSet11.Tables("wtab").NewRow() Row.Item(0) = TextBox1.Text Row.Item(1) = TextBox2.Text Row.Item(2) = TextBox3.Text Row.Item(3) = ComboBox1.Text Row.Item(4) = ComboBox2.Text Me.DataSet11.Tables("e").Rows.Add(Row) Me.OleDbDataAdapter1.Update(DataSet11, "wtab") BUT …