3,459 Topics
[CENTER][COLOR=Navy]Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002[/COLOR] [COLOR=Navy]Can anyone please help me!! Thanks Jay[/COLOR][/CENTER] [CENTER][COLOR=Navy]AND MY INPUT MASK IS …
im making a registration page for a charity event. ive designed the form in dreamweaver and attached a simpke version of what i want it to look like. now im stuck of how to get this information and have the results put into a access database. i know i have …
right when i type the date in a need a validation for it dusnt allow u to book any less than 7 days in advance from NOW (DATE cz i dont want time included). If longer then 2 months in advance also dusnt let u for as computing course work …
right when i type the date in a need a validation for it dusnt allow u to book any less than 7 days in advance from NOW (DATE cz i dont want time included). If longer then 2 months in advance also dusnt let u for as computing course work …
hey guys, i have created a database using ACCESS, i have one table and i have created a page for the front end, this database is for my personal use, in the table i have the column for email ids, now i have about 110 email entries and i wish …
right when i type the date in a need a validation for it dusnt allow u to book any less than 7 days in advance from NOW (DATE cz i dont want time included). If longer then 2 months in advance also dusnt let u for as computing course work …
Hello We got to work in MS Access with creating this database for a company. Anyway I have a problem with a form where I will registrate new Products cause I don't want to have one of the secondary keys in the form even, but it keeps telling me I …
hi, i need to create a control button on a form that prints a report and then goes to the next record. Any ideas? Thanks
Good Day, Can anyone on this forum elaborate on comparisons of performance and functionality between SQL Anywhere and Access? Regards, Keith :?:
Okay here's where I am at currently... RELATIONSHIP: Personal Profile ---One-to-Many--> Receipt Totals ------> Service Performed The personal profile & receipt totals are connected via Customer ID while the Receipt totals and the Service Performed are connected via Receipt ID I have them all together and they work just fine. …
trying to get back into programming after 10 years out. this is very simple i'm sure but I get an error message 'invalid syntax, missing operator or operand when I enter this into my control source box in access reports module. Can anybody help? Thanks
I have a macro that copy-paste from a sheet to another... in that file i need to change the name of the sheets all the time, but the macro code does not understand that and gives me error... Sub Copiar3() ' ' Copiar3 Macro ' Macro gravada em 02-12-2005 por …
Hello Everyone, I don't know anything about VB.net. Just wanted to know if it is as simple as VB 6.0. Last semester I had done a project on DBMS and had used VB 6.0 as front end and MSAccess as back end. This time its a project on RDBMS. I …
Program- VB 6.0 Database- MS Access 2003 I'm build a database base on my household bills. And I have already the database connects to the program, but I am unable to get some of my functions to run correctly. These are the problems that I am having... 1. I am …
Hi there, I am not the bet in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access. Anyone help with quick steps on how to do this, It would be greatly apprciated.
As an applications software VAR, I have a user who received the message "Disk Full" or "Out of Disk Space" or similar. I explained that this was down to a Windows Access Issue of some sort.Their IT support supplier eventually agreed that it was their setting of the users Disk …
Hello all, I hope that this is in the right place - sorry if it is not. I have an asp script (which is contained in a .vbs file) that takes info from an XML page and inserts it into a database. I was trying to get the the script …
Anyone been through something like this and have some good suggestions? I have a password protected MS Access database that stores comments (as well as a slew of other things) that people are updating. I have the same database on my home computer that I use to update other information …
Hi all, I'm importing external data into Microsoft Excel XP from a database. Not wanting to query all 70 databases we have I'm thinking a macro or some visual basic would work nicely to automate this. However, I'm stuck because everything I read tells me that one cannot query multiple …
Hello all Programmers, I am preparing a website with login credentials to a welcome site. I need help in the following: 1) create a registeration page where by the user enters their username, password and email address 2) once the user submits the details, records are inserted into users database …
Hi everyone, I have a problem in inserting radio buttons values into my MS access database. I have done it with PHP, but I need to do it with ASP. I am trying to create a survey and I need to collect the responses in my database for further reports. …
Hi there, I am not the bet in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access. Anyone help with quick steps on how to do this, It would be greatly apprciated.
Does any of you know what DBMS products are suitable for internet database system other than Oracle 8[I]i[/I] ? Thank you?
Home Search Assistant. That's my problem: Logfile of HijackThis v1.99.1 Scan saved at 10:19:35, on 08/11/05 Platform: Windows 98 SE (Win9x 4.10.2222A) MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106) Running processes: C:\WINDOWS\SYSTEM\KERNEL32.DLL C:\WINDOWS\SYSTEM\MSGSRV32.EXE C:\WINDOWS\SYSTEM\MPREXE.EXE C:\WINDOWS\SYSTEM\SPOOL32.EXE C:\WINDOWS\SYSTEM\MSTASK.EXE C:\WINDOWS\SYSTEM\mmtask.tsk C:\ARQUIVOS DE PROGRAMAS\ALWIL SOFTWARE\AVAST4\ASHSERV.EXE C:\WINDOWS\EXPLORER.EXE C:\WINDOWS\SYSTEM\RPCSS.EXE C:\WINDOWS\SYSTEM\CMMPU.EXE C:\WINDOWS\TASKMON.EXE C:\WINDOWS\SYSTEM\SYSTRAY.EXE C:\ARQUIVOS DE PROGRAMAS\ALWIL SOFTWARE\AVAST4\ASHWEBSV.EXE C:\WINDOWS\LOADQM.EXE …
Hello people! My business PC is infected with HS and i really cannot remove it! I had the same problem with my home PC and it was successfully removed, but i use the Windows XP there and 98 version here. I'm posting the HiJack This log! Please help-me! PS: Sorry …
Hello, I have a few web applications that I have been running on one of our web servers at work and everything is fine. Rearrangements have come about and a change of server is needed. Therefore all the intranet websites/applications on one server were moved onto a new server. But …
hey guys, I know that in VB data can be taken from an access database then displayed in a flexigrid and I was just wondering is it possible to display the same data in a series of labels rather than a flexigrid as I was thinking about doing this for …
I need to create a field in Access that included both text and the autonumber feature. We are a non-profit hospital organization and we have multiple locations so we want to create an ID field that is unique by location and still uses the auto numbering feature to generate the …
hi, im a newbie in making database program using vb and access as database..i have problems on how to run my search query correctly, actually i have two tables that i'd like to connect with, attached hereqith is my sample program.. could somebody pls help me...
I have just had the dubious honor of being given a 500k Access database to manage that is not allowing me to do any inserts. I have administrative permissions both as a db user and on the db itself yet the insert button and drop down are all disabled. There …
Hi, Here's my task. I have to setup a Crystal v10 report to print a label to a tharo barcode printer whenever the record is saved in the access db. Or maybe setup a checkbox "Print Label". When the checkbox is checked and then the user hits save, that would …
is it possible to have a validation password while open a MS Access password?? Where should i set it and how can i set it? the open connection or? pls advice.... thanks...
I was wondering what the pros and cons of form and field validation are?
Hi, For a project of mine, I've implemented user registrations. However, one thing I have NOT implemented is the ability to check if the username requested by a new registration exists in the database. How do I do this? The code for the registration page is as below: (btw, I …
Logfile of HijackThis v1.99.1 Scan saved at 11:17:07 AM, on 10/17/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) 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\Explorer.EXE C:\Documents and Settings\Administrator\Desktop\HijackThis.exe R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = [url]http://www.dell4me.com/myway[/url] R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = [url]http://www.dell4me.com/myway[/url] R1 - …
I am trying to use the data form wizard to create a chart for my program using the information in a database. On the section that asks you to select the database, I click browse, go to whre my database is saved and click ok. When I try to click …
when i click a link into my page, it will then open a new window which is connected to a database. when it loads.. after 2-3 seconds the "Page cannot be displayed error" will then occur.. is there something worng with my connection? what is the problem with this? i …
I'd just like to know if anyone can point me to some good resources for creating charts in Access 97. I'm trying to modify a bar graph and I can't get it to do what I want to do. I haven't done much work with charting before and everything I've …
Hi, We are using microsoft project 2003 and some pc still using 2002, and project web access. However there is some problem while updating and publish into a project into our project server. Some project that are created with microsoft project 2002 are not updatable and publish, is there someone …
Hi, Is their any way to create user and assign user rights/permissions for any table(s) in ms.access through vb6 code (ADO / DAO). waiting for your reply. Ahmed
hi im using VS .net, MS Access and c# language. basically i tried to do an update command using oleDbDataAdapter and commandbuilder. i also searched for tutorials but i still cant get things going. could someone please tell me how come i couldnt generate update and delete commands using oleDbDataAdapter? …
:) pls: what is max access database size? how many records per table is maximum allowed in access 2000? i am going to need a database with aprox. 50 000 new records per year, is access 2000 a good choice? TNX!!
Our organization uses an Internet website to create travel orders. The orders are sent to their supervisors for approval. Many times the employees forget minute details such as taxes. I want to create a basic report system which allows a user to check (from a list) all that apply; i.e. …
i decided to switch over to ms access (thinking it would be easier) from mssql but i am having the same problem that i had with ms sql: "SQL Server does not exist or access denied" i have put the ms access db into the web server from the web …
hello every body i have a search button just like in google or yahoo but my search button is connect from my access database table , basically search option is use in my site for product available for sale for example when customer type name of product in search option …
Okay, another easy one, but I can't remember how to do it. I have a table that I want to be able to update multiple records in. I thought I could just run an update query, but I have 2 yes/no fields and one text field that I want to …
I know that if I have a program with a connection to an Access database, if I change the name of a table in the database, when I try to access that table from within the program, it's going to throw an exception. My question is, how do I cause …
I'm having the following problem and can't find a solution: I have an app with four combo boxes, each of which gets its selection list from tables in a database. Each table has a form that can be used allow the user to populate that table. I have one Combo …
Hi I have a C++ dll which was designed to handle an Access 97 database using dao classes. I now need to convert this to Access 2000 / 2002, but when I run it, I get 'database format not recognised' errors. Presumably, I need to recompile with different settings somewhere. …
I am making a database that tracks the inventory of a tool room. This includes info about both shelf tools and tool box inventories. Each inventory has about 300 items in it, and there are about 9 kits. The info was already put into excel, and instead of re-typing the …
The End.