[microsoft:access] Forum Topics

[COLOR=#555555]I have a table where the user will enter a commencement and ending date and an amount that was charged for the period of time. This is all on a subform, link together by an account number. Also, each record on the subform, may have multiple dates For example:[/COLOR] [COLOR=#555555] …

I Want To copy tables and data from 1 database and paste it to another database how can i do it in VB with MsAccess as back end

I hope some one can help me!!!! (hopefully) I am trying to import tables from a Sybase database into Acces 2000 but I have no clue on the Vba script that will do the job. because Access does not have a macro recorder I'am having a hard time learning. the …

Hey all, Found this site through Google. I've been browsing the threads and it seems like this is the new May fun surprise. My Dad's up in Rhode Island and I'm in DC -- he called down to say that he's got this and doesn't know what to do with …

Hi, I'm currently creating a database and need to create a query to show all the records that the warrenty date expires within the next week. i know this is a simple query as I did it when doing my A-Level in computer studies however I was working in a …

what are all the different types of data checks you can use in database tables such as field length check and range check

Hello Message popup everytime log-on to the computer like this: "Error loading p2esocks_1012.dll The specified module could not be found" Would anybody help me to get rid of this please.... Mandoos

okay i have downloaded the business template for filemaker pro 8, and have been racking my head all day. I have been able to setup an inventory system for the apparel company i work for complete with the size quanities. My only problem is i can't get the sales order …

Logfile of HijackThis v1.99.1 Scan saved at 3:03:42 AM, on 5/3/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.5346.0005) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Creative\SBAudigy\Surround Mixer\CTSysVol.exe C:\WINDOWS\system32\dla\tfswctrl.exe C:\Program Files\CyberLink\PowerDVD\DVDLauncher.exe C:\WINDOWS\ehome\ehtray.exe C:\Program Files\HP\hpcoretech\hpcmpmgr.exe C:\WINDOWS\system32\spool\drivers\w32x86\3\hpztsb12.exe C:\WINDOWS\system32\Rundll32.exe C:\Program Files\Trend Micro\Internet Security 12\pccguide.exe C:\WINDOWS\stsystra.exe C:\WINDOWS\system32\LVCOMSX.EXE …

Saving information from .NET webcontol into access(database) I am doing a Job hot system, my webpage consists of buttons, text , .... Each time the new user fill the form , the submit button is clicked how can i move all information from this form to Table (database).. Also, how …

Is that possible? How can I procesed data with PHP from an Micosoft Access Database?

Hi, I have column with alphanumberic fields like: trader1.dbpt 1234.mcxl abc243.cexl 234-lab.cxcl There are following characteristics of this data: -fifth last place is always decimal -always four characters after the decimal What I want: -only those rows which have ".mcxl" at the end -rows should NOT have numbers in them …

im having some problems in launching an ASP.net, C# site im having troubles in making virtual directory over there and most irritating the custom error mode in the web.config. plus i wanna to place my ACCESS database on the domain but im unable to find the correct physical path to …

Hello, I create a database where students put their names and name of events to sign up. I work for an university and I already creatied the system. My question is, I would like to know how I can make the Forms to be public in order to put them …

Hi, I have a composite in a Microsoft Access Database that is not populating, when I add data to the two tables connected to it you would expect the Composite Key to populate as well wouldn't you? But this is not happening, can anyone expalain why and how this problem …

I am looking to be able to pull up files from ms access using C++. this is for a college senior project. We currently have a rfid reader that will read a tag and display its unique tag number using C++ we now want to link each tag to a …

Hello I am new to csharp and am having some trouble with a projec that I am working on. I have a database(access) and am using a window form for a login page. The login is supposed to check a couple conditions and then return an int from the database …

[U]Access 97[/U] I am developing a system and am getting the following error on compilation - "Cyclic reference of projects not allowed". The help system advises me to resolve the reference but doesn't say how. The compilation window does not highlight the error in the code and I can't figure …

Hi all, I am a beginer in VB.NET :rolleyes: .... now, i am working on a project so as usaul we wonder if we could do something .... etc. I write the whole application in VB.NET but i observed that i need to write a few line C# code inside …

I have recently developed a web based database application using microsoft access and dreamweaver. I have used coldfusion to link the database to the html webpage. The website runs successfully at my clients address. However, after transferring all the files to my university web space I receive the following error: …

I set my access database with password is 123. I wrote VB code to connect to this database: Dim db as Database set db = OpenDatabase("C:\data\db1.mdb", false, false, " ;PWD=123") Get a error: Couldn't find installable ISAM. Please some one help me.

Hi guys, Right now I develop a website that use Microsoft Access database. So, I've developed a database that store all my pics and videos. But when I tried to make a recordset (this is a command in Dreamweaver MX, as I use it to develop my web pages) to …

I'm unable to format the date fields when I export from Access 2000. I'm trying to generate a report that has to be comma delimited, strings in quotations, and date as mm/dd/yyyy. Everything looks the way it should until I export. I get mm/dd/yyyy 0:00:00 everytime. There are several tables …

I'm converting from MS Access 2000 database to a Visual Basic front end with Microsoft Access back end. In MS Access, I can give a text box a default value. For instance, I'd like a text box to default to the system date. I can't seem to find a way …

How can i Transfer a Particular Record from 1 Data Base to another.. i am using ADODC control and MS..Access database

I have a MS Access db that I use on my local machine to generate numerous reports etc. currently I am manually downloading a copy of the table from the online Microsoft SQL db which contains the data I use in generating these reports etc. I would like to link …

i have 13 textboxes and a picturebox to display the details and picture of student respectively.they are sorted by the admission number.i am using access as backend.my front end is visual basic 6.0. i have another form with a text box and a command button.when i enter the admission number …

Hey, I'm currently working on an A Level project in access. I have a 'date of entry' and a 'order expected date' field in a form (these fields are in two separate tables, the form has been created via a query linking these two tables together). I want to put …

I Have Upgradin my VB4 Projekt To VB6. I have a connection to MS Access, but it is still not working. The Recordset is not found. My question : Do I need additional DAO .dll's or something else to run my program with VB6?

Hi im Paco When im looking for information about programing, i found this forum and i belive i can find help here if you can help me i gone apriciate that. ok my problem its whit visual basic 6 i dont know how to manipulate data bases of acces from …

Hi there, I have a system built in VB_6 professional which reads from an access database. I need to search for a specific record using a word or short description entered by the user. This will link to the DESCRIPTION field in the database itself. Not being case sensitive would …

Is there another way to make a column in a table the primary key if you already assigned it to the autonumber column? I would like to make either the student id or the social security number the primary key.

Logfile of HijackThis v1.99.1 Scan saved at 6:29:45 PM, on 3/16/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Unable to get Internet Explorer version! Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Windows Defender\MsMpEng.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\Explorer.EXE C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgemc.exe C:\WINDOWS\System32\CTsvcCDA.exe C:\WINDOWS\System32\nvsvc32.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Java\jre1.5.0_04\bin\jusched.exe C:\WINDOWS\System32\spool\drivers\w32x86\3\hpztsb04.exe C:\WINDOWS\BCMSMMSG.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgcc.exe C:\Program Files\Common …

I have some accumulated error data organized by week. How can I write a query to pull the top 10 or top 10% for each week and show them in the same table? I will need it to be flexible enough that it will continue to function properly as I …

Hi everybody, I hope you can help me tackle this little pb. OK, I need to create an access database aimed at booking salesmen trips to different cities (NY, Dalllas, Washington, Miami). Basically, I'm using 4 fields: Saleman, Location, Star Date and End Date. Now, I need to create a …

Hi Iam using Borland C++Builder6 ..This is the first time I use BDE I ve read some tutorials and articles and Ive tried to create an alias for my *.mdb Microsoft Access 2003 database so that I can access it from within the application but it does not work. What …

hi... would you help me... i can't understand about connection database from access. i will using this db in my project.. help me pls... thx...

There seems to be a serious number of posts regarding the use of VB with an Access Database... Due To The High Volume of questions about access, I'm posting this link. Please, Go through the tutorial, and if you have questions regarding access with VB still (after reading through the …

I'm working on a MS-SQL-Server-DB with MS-Access. There are some dozens of forms. I'd like to translate the forms by button-click into another language. I've made a procedure (sub) called by button-click which walks over the complete "Controls" and changes the captions. So far, so good. But this procedure (in …

Hello all! I need to fill a database using microsoft access and sql in an asp page. I need to check that the input is not exsit yet, so I use the following to create sql sentence: tempsql = select * from table where filed= '" tempsql = tempsql & …

Hi, I created a report that prints a collection of pictures (jpg files). But it turns out that one pic will occupy one page. How do I create a report that display the pictures continuously? This means that if the pictures are small, more than one can occupy one page. …

Hi, I would like to have a asp.net application that will let me extract or import data automatically to my Access Database. For that, I have a .csv file and I will then upload it and will be extracted into one of the table in my Access Database. Is there …

I havn't used this specific computer in a while, so I just wanted to double check it didn't have spyware before I started using it. No problems, just wondering if someone could look at the HJT log. Thanks. Logfile of HijackThis v1.99.1 Scan saved at 6:50:14 PM, on 2/17/2006 Platform: …

Hi everybody, I have been asked to build tools like you will find at [url]http://www.stevenscreek.com/goodies/pi.shtml[/url] [url]http://www.fitnessandfreebies.com/tools.html[/url] [url]http://www.global-fitness.com/freetools_m.php[/url] I sincerely do not know as I dont have a ready database to retrieve data from for these calculations . Please could anyone tell me from where i could find such data ? …

Table 1 Freeze date = Date/Time Pouches on Date = Number Pouch Number = Number Strain = Text Quanta Results = Hyperlink pH = Number Clot Result = Text Frozen by = Text Date used = Date/Time Notes = Text Sample Code = Auto Number Primary Key The sample code …

Hello, I have a windows application on VB.Net and I connect it to a MS Access database placed on a server. This application is multiuser (50 users aprox reading and writing data), all of them can access the application at the same time with no problem. This application works Fine …

Hi everyone, I'm keen to use Access as a client application to access data from a MySQL database. The reasons are Access for its strength in reports creation and MySQL for its stability and scalability. I also intend to site the MySQL database with a web hosting service provider. This …

[b]Can anyone please tell me what is wrong? Access keeps trying to tell me that I must install Microsoft Jet 4.0 Service Pack 8 so I downloaded the file and started to install it and suddenly the installer says that I already have a newer version than the one that …

Hello , I wish to Duplicate certain Fields in the same tables when i open a new form that is related to that same table . If i create a button of Duplicate Record , he will duplicate the Primary Key - which i do not want to "Duplicate OK" …

Wonder if anyone could possibly help by pointing me in the right direction towards the problem that a friend of mine is experiencing while working on Microsoft Access. Firstly, he's "Account No" field with Data Type as "Number" & in the "Field Properties" at the bottom, he's Field Size set …