[microsoft:access] Forum Topics

I deployed an online quiz in my site using Access as my database. The question is randomly selected from the database one at a time so that multiple users using the application at the same time will receive a different question. The users answer is also stored in the same …

I am currently working with an application that involves the creation of new table when a user had pressed a button. I am using an Access Database with a name AcoountReg.mdb. The table should compose of the following fields - ID (number), Stud# (number), PGrade (number)... and so on. How …

ok bare with me here, not sure if this is the correct forum section but I will give it a go. First some background. Some time ago I signed up for Microsoft Office live business website...it was free and all that good stuff so i went with it. I ignored …

I would like code to populate comboboxes with data from my MS Access database. I can do this with textboxes, but have hit deadends when trying to figure out how to do it with comboboxes and listboxes. Each database has a minimum of two fields. A description field and autoincrementer. …

Hi All. I am new to this web site and find it very helpful. Keep up the good work. I am also a Novice ( at best) when it comes to programming but really would like to master VB. My question is, As I design my form, I would like …

Hi guys. i hv the problem here dat i did the project in VB6 with connecting with MS-access2000, the problem is dat i coudnt setup the prj in my machine(i got the exe file then i did the wizard deployement package), anyone those who can understand this problem, pls solve …

Hi, I have imported all my tables from Access and trying to get up to speed with filemaker on my mac but I'm having problems. I want to copy two fields in table view and paste them into 50-100 other records but I can't see how to do this. Firstly …

I need to get a total of a specific column of a table of access db in a text box in my visual basic application. What should be the code? I am using adodc to connect with the database. Help urgent please..........

Hi guys, I'm fairly new to MS Access and I am running Ver.2003. I have a problem with comparing a Excel speadsheet with an Access DB. The result I require is as follows.... If field 'Last' and ID Num in Excel speadsheet matches 'Last' and EmpID in Access DB then …

hi everyone. just had a question. iam trying to link ms access to a sybase database which i was able to do through odbc. but everytime i link the odbc driver keeps prompting for the user name and password to connect to sybase. is there a way to save this …

hi, i hv a residential facility reservation database in which the facility can wither be a hotel or a guest house. Now, i hv created these tables(along with many other) ############# Facility Table Facility ID Facility Type Name Number of rooms Address City Phone ############## Table Hotels Facility ID Tieup …

I'm looking into creating a Access database for marking my students and so they can get there marks online. The online part is much later mind you but that is my goal. I need help in the structure of my tables, quaries and reports. I've been using access for a …

Hi guys, I have a problem with the conversion of an excel spreadsheet to html. I have converted the file to html using a microsoft internet wizard and the spreadsheet comes up yet the cells that need user input - you can't enter values. I am a newbie and have …

i am doing an acadamic java project by using html, servlets. in html form tag what is the url that i have to give in post attribute. and i am using access as my database. it is giving that httpserver error that given table is not found. will u please …

Hi, Does anyone know how to make ms access online & shared by different users? Thx...

Hello everybody, Please somebody help me...I am trying to save webpage data on the access database (remote server)...on the local host everything is going fine....but when i m loading my web page on remote server and trying to save the data to the ms access database then i could not …

Hi i am making a table where i have different currency fields showing the salary of different staff and then a total field where i can calculate each staff's salary on rent, transport etc... now how do i make the total field show the total i.e. addition of rent+transport+education

Hello! I have an SQL query designed to search a string field and return results based on input from the user. If I use VB.NET to interrogate the Access Db using the following SQL: "Select *FROM TRAINING WHERE ((Trainer Like '*Rob*'));" I get no results. If I perform this same …

Hi, I have been struggling to design a form, so that the form can be escalated from person A to person B, then person B to person C and so forth automatically. The person A only needs to click at a button (exp: confirmed?), then the form will be sent …

Hi All.. I am trying to access records and edit and save the changes .. Here is the code Private Sub cmd_edit_Click() Dim addnew As Boolean rsnew3.Open "select * from company", c, adOpenDynamic, adLockOptimistic rsnew3.addnew If text1.Text = "" Then MsgBox " enter the company name" text1.SetFocus rsnew3.Fields("text1").Value = text1.Text …

We are using two access databases and we are able to manipulate only one. But we need to insert records in two databases with the same field name simultaneously. Wat do we do? Pls help us out.

I have a form that is supposed to update tblMain in my database, and when I press btnSave it says in a messagebox, saved, but when I look at the table or try and recover the data from the dataset all I see is NULL values. Any help would be …

I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the MySQL syntax for it, but I can't seem …

[B][COLOR="Red"]Hello I am new to this site I wish you to help I use Visual Basic Version 6 and database ACCESS would connect database to the server So I can use the database in more than one device Example If the two fields in the database the First for the …

I need to calculate the approximate current age in years of patients at a clinic. We don't have the birthday of all the patients, but we know how old they were when then first registered and we know the date they registered. I am doing a calculation which returns some …

I know how to calculate a person's age based on their date of birth but is the reverse possible? I would like to display a person's DOB in a form using their age. What is the formula for this and how do you implement it?

Does anyone know how to use data to call access database ??

hi frnz!...m a comp. Sc diploma student n m in2 my final(project) semester....whre we need 2 submit our own projects. i hav been asked 2 prepare a Quizzing software...much similar 2 those conducting online exams lyk the MCSE etc....based on VB n MS-Access. plz help me on how 2 start …

Hello I need help in microsoft access. I am creating an electronic database so i need 2 events, 2 resources and 2 agents for example event (order) resources (product). and i also want to know how do we link the table with each other i am talking about relationship Thankyou …

i need a code for adodb which can link my form in vb to a table in ms access which contains name and id as the fields.help please!! thanx

I have a list box set to simple multi select option. I want to be able to pass those options to a text box. If I have multi select set to no, the value appears in the textbox fine. Whether I set it to Simple or Extended, it doesnt seem …

HAI! CAN ANYONE HELP ME TO RETREIVE DATA BETWEEN TWO DATES FROM MS-ACCESS USING VB.NET. I HAVE TAKEN DATETIMEPICKER CONTROLS. THIS IS THE CODE . ITS RETURS ERROR. PLEASE SOLVE THIS PROBLEM. Imports System.Data.OleDb Public Class Form7 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private …

Hi, I am using Microsoft access and started developing a software for the admission of the college(10+2+3). but my problem is that i have done newuser creation, Change password coding but i am not getting an idea for forgot password. I have searched little bit on Internet but no luck …

Hello, I m Ehtesham I m a Database Programmer (Ms Access) and Network Administrator in Cement Industry. My Intrests in DataBase Programming and Networking I would like to leran more in these Fields from every person. I hope all persons help me in getting knowledge form all members. Thanks

Hello! Thanks in advance for any help you can offer...I don't know too much about this stuff. Last night, my computer starting randomly playing a broadcast even though nothing was open to play it on - it was just audio playing by itself.... The computer was also lagging a lot …

Hi all. I really need somes help from you. My networks have 20 Pcs and have workgroup is Hochiminh and use normal IP config like this : 172.27.54.2-->20 255.255.255.0 172.27.54.101 210.245.31.130 My trouble is have one PC was attack by mass-email virus. After cleared all virus, my computer couldn't see …

I need help with this question. Given the following database notation: tblPasswords(Employee First Name, Employee Last Name, Employee Password, Employee Department, Installed Software) Break the above flat table into the following related tables: tblEmployee(empNumber*, DeptNumber, ...) – A listing of all employees at Acme Inc tblPassword(PasswordID*, empNumber, ...) – Contains …

First hello to every one in this forum. Well I am using MS Access 2003 for building a database. [B]I am usign 3 tables.[/B] [LIST=1] [*]Students [*]Books [*]Request [/LIST] Both student and books table has one to many relation with request table. I am using MS Access Forum for all …

Does anyone have experience with "Actual Installer" by Softeza Development? I am looking for a product to create installation packages for Access mde runtime distribution.

Hello PHP experts how can you detect [B]'[/B] character in your search field? Because every time I input the word [B]hilgard's[/B] it returns an error I think because of the character [B]'[/B]. This is the error [CODE=php] Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) …

HI I need to make Microsoft Access 2003 Dependent Drop Down from an existing application which set a configuration file. The user interface contains many drop down that are filled dynamically. The issue here is the latency, meaning the time needed to refill the drop down after making a first …

Hi there! I'm having serious issues here. Explorer keeps crashing whenever I try to access anything in it - example, my documents. I can see the files for about a good 15 seconds before it crashes, and then I lose the start menu, taskbar, and things on my desktop for …

hi friends i have problem i want to store the firewall log file which in .txt format.i have read the txt file using visual basic and store the data in MS Access and also display the data in MSHFlecGrid at same time. plz some one can help with is problem.i …

i am using VB with access. i need to load the values of a particular field in a table to a listbox . i used the following coding in the Form_Load event. [COLOR="Green"]Set db = New Connection db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;" & "data source= " & App.Path & "\test.mdb;" Set rs = …

hi, just wondering if there is any code out there, that could link a micro$oft access 2003 database to a webpage, im intending for it to be an offline page, so it would only be running on the same computer as the database. thanks, darren

I have 2 forms; one called frmLogin and another called user_info. On frmLogin I have a text box called USERNAME and a command button. When you click the command button the following code is run: [COLOR="Red"]This Code Works (Or atleast It should)[/COLOR] [ICODE]Private Sub Command29_Click() Dim strUSERNAME As String Dim …

I`m doing a project in VB to conduct a Quiz competition. I`ve succeeded in creating databases & tables using ADOX. The problem is how can I retrieve all table names from a database using ADOX? with regards Robins Antony.

hi i want to do operation on image...i have extracted the pixels of small window of 15 X15.. now i want to save that matrix in ms access 2003. for the further opeartions.... have the data in 2-d array say a[15,15], and since there is no build in data type …

[B][COLOR="Red"]<<This post is regarding Microsoft Access>>[/COLOR][/B] I have created a text box (not combo box) and a command button. The textbox is called USERNAME and the command button called LOGIN. What i want is a script that will open the form "user_info" and display the record based on what the …

Hi, I'm trying to connect to a MS Access database on a server in PHP without having to use ODBC does anyone have any idea or know how. Please help? Thank you.