1,557 Topics

Member Avatar for
Member Avatar for pker walker

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 …

Member Avatar for Kegtapper
0
101
Member Avatar for Melotron

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 …

0
107
Member Avatar for mxcsquared

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. …

Member Avatar for Edward Kinlen
0
80
Member Avatar for ALAN SMITH

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

0
72
Member Avatar for policy10

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 …

0
77
Member Avatar for ambiguus

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 …

0
61
Member Avatar for TKSS

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 …

0
151
Member Avatar for hopkins1878

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.

0
89
Member Avatar for Kakashi

Does any of you know what DBMS products are suitable for internet database system other than Oracle 8[I]i[/I] ? Thank you?

0
64
Member Avatar for sweetpeakate

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 …

Member Avatar for campkev
0
72
Member Avatar for LIMS2LIMS

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 …

0
74
Member Avatar for little_lisa31

I was wondering what the pros and cons of form and field validation are?

0
84
Member Avatar for balor

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 …

0
63
Member Avatar for RustyCanadian

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 …

Member Avatar for Velvet
0
117
Member Avatar for J_Search

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. …

0
46
Member Avatar for sgtrock40

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 …

0
82
Member Avatar for sgtrock40

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 …

0
108
Member Avatar for yoavgold

I want to develop a new app. for Windows Mobile 2003 that based on Access DB do you know about a nice place where i can read about it and get some nice tips? If you know about some other app. that uses access DB or any other DB for …

0
89
Member Avatar for dru987

i have a very simple access DB and im tryin to update the records but the update never works. im using asp.net/vb.net and i've include the execute in a try/catch block and it always prints the sql string (the catch). here is my code, perhaps i have an error that …

Member Avatar for weilander
0
179
Member Avatar for hippychic43

Heya, I have a table that has a primary key that is generated automatically by the database, so when I write an SQL statement in my program to insert information into the table, I insert values for every field but the primary key field. The problem here is that in …

Member Avatar for Alvein
0
110
Member Avatar for sham
Member Avatar for Clonman

Hi All, I am new to working with Access and would like help to stop a security pop up on users when starting Access. It does not happen on all my users but as I plane to rollout Access via citrix I feel this pop up could cause problems. I …

Member Avatar for Estuardo
0
122
Member Avatar for helpwanted

I have a table containing the fields: DeliveriesID // SupplierID // Date // ProductID // QTY // costprice // totalprice I need to make this table 1NF. I know I should make related tables but I'm not sure what fields go with which.

Member Avatar for Estuardo
0
148
Member Avatar for V_W

A project a do at my job is a monthly report using Excel spreadsheets. I enter raw data and get calculated totals, averages, etc. Nothing very complicated. Each worksheet is a month, the workbook is a year. No yearly summary is done. Now my supervisor wants some new additional info …

0
68
Member Avatar for berimor

Hi guys, can anybody help, plase. Is there an instrument to manage .edb file (as far as i know Oracle's Enterprise DB but under free licence)?

Member Avatar for jwshepherd
0
168
Member Avatar for alexanderp513

Hi< I Have Sticky Keys On Right Now And When I Pushed Cancel It Still Didnt Work> Whebever I Push A Key The Shift Charcter Types Out And I Dont No How To Get This Off> It Is Awful> Please Help

Member Avatar for jwshepherd
0
80
Member Avatar for sham

Can anybody help me understand difference between form_load and form_open event in MSAccess?Which event occurs first?

Member Avatar for jwshepherd
0
103
Member Avatar for Vasago

HI all, Im looking for a program that will work with WinXP(shareware or freeware preferred) that works basically like the startmenu. Its for and inventory thing im trying. Needs to give a list of choices and if you click one, it will open a sub box with a new choice …

Member Avatar for jwshepherd
0
145
Member Avatar for bouzahme

Hi, I am designing a scan folders software, I need to save all information about files (name, extension, size, attributes,...) in ms access Database (It's a requirement). My database contains about 85000 records to be diplayed. I tried to use ADO to paginate, but I need to retrieve from the …

Member Avatar for afgmail
0
106
Member Avatar for sham

Can anybody help me understand difference between form_load and form_open event in MSAccess?Which event occurs first?

0
51

The End.