Search results for query: *

Hello anyone, I just wanted to ask if anyone noticed anything funny about their queries not working in MS Access 97 this new year, 2002? I built some queries in an MS Access97 database within the past three to four months, which worked fine until the new year started. Now they seem not to...

Hello. I am trying to show the "Form View" and "Database" toolbars when a button on a switchboard form is clicked... I have a switchboard form in a database. Some of the users, not all, need to obtain full access to the database and database window. I have set up a...

Hello All, I know this is a easy thing to do and I am not that familiar with Access so everything seems hard to me, but I have an Access 97 form that has a close button. I want a message box to appear asking the user if he or she wants to save the record. They can either okay it or cancel it...

Thanks for your help, Joe! It works. I had no idea it was that simple. I thought I'd be slinging VB code for days. :) RTA

Hello. I am a novice at VB and actually at SQL, although I have been working more with SQL, so please bare with me. Here's my dilemma... I have a database and one of the fields is called SI_Name (a text field), which is the name of a person that inputs their own records via a form. One...

Hi Joe, I have checked each field that I have and their specific validation rule line in table design view, but there's nothing there. My data, which I am appending, is still breaking a validation rule, even though none is visible for the fields I am working with? Please let me know. Thanks...

Hello all: I have an Excel spreadsheet that I have appended to an Access table-let's call it table 1. In table 1, not all of the fields will contain data. This table will then be appended to a larger table in the database-let's call it main table. Whenever I try to append, via an...

Okay, I'm a little new to this Tek-Tips thread thing. I realized I posted my own thread, when I really wanted to reply to you. But anyway. Here it is... The data is actually not being appended because of a validation rule error. What's this error all about and how might I be able to fix...

You know what, the data is actually not being appended because of a validation rule error. What's this error all about and how might I be able to fix it? Thank you sooooooo much. RTA

Hello. I am trying to import an Excel data sheet to an existing table in an Access database and I am getting an error message that all of the data was unable to be appended-the data was lost or deleted because of key violations. In the existing database, I have a field called entry_number...

Kathryn, The relationships have already been created. When I tried to choose Cascade Update, it gave me an error message. But yes, when the wizard asked me to choose my fields, I picked the same field name for all of the tables. How should the relationships be set up? Shpuld I link all the...

I have created a form with four linked tables. In these tables, there are more than one primary key, with the same name. The tables are joined together through only one of the primary keys, kwp_id. My table names are approval rate, cycle time, rfcs and rev team questions. Access generated a...

I have five linked tables, I want to be able to enter data on a form that updates all the tables automatically that have the same fields. What need I do? Thanks in advance.