Search results

I'm stumped ! I defined teh field 'User' in 'USER_LOG' as the Primary key ( index : Yes(no duplicates) If i open the table and add a primary key 'abc' that already exists it throws the expected error and does not allow the table to be updated However If i do the same using teh foll code in...

Hi , Thanks ! You understood perfectly! :-) But I didn't quite understand the solution you suggested. Quote : "One thing you could do is check when you are inserting the login to verify it is not there. That would cut down the checking time if you are going through to much code." I am using...

Now isn't that SMART!!! thanx so much!

is it possible to have a combo box display values from a query AND list values ? e.g. I have a query [Status] which has values '123', '234', '1234' can i have the rowsource of my combox as : select * from [Status]; 'All' Thanks for anny help in advance, Gina

Hi, I have a multiuser Access database. The login form has a dropdown displaying the names of all users. and any1 can login as any1 from different machines. I've created a table USER_LOG, which records the Network login name and computer name when a person logs in. ( thanks to all the big...

Thanks Casey !!! I should have looked there!

Hi , Does anyone know the significance of the contents of the lock file that Access creates? I have a shared Access database. Looking at the .ldb , I assume it is the "computer name network login name" If any1 else accesses teh database his/her "comp name login name" would get added to the...

If you are going to import the file into an Access table ultimately , Then why do through the process of converting it into text, when u can directly import it as Excel. Maybe I haven't understood your question .

Well i did just that , but it would not allow me to change the date format of the exported field in Excel. I re- created the query from scratch and this time I rightcliek on the field in the query and defined format as "Short Date" and now it works perfectly. I output the query and i can...

No I don't think it matters If u are using email, it means you have an SMTP server in your network! I don't know why it doesn't show in your internet headers box. hope u are looking in the right place. U could try checking the options for a email which has come from sum1 outside your network...

Are you looking for your SMTP server ? If you are using MS Outlook 2000, go to your inbox , right click on any email --> options. in the internet headers you should be able to find the IP address of your SMTP server. That's one way I know of finding it. Gina

Thanks ! But if i transfer it to Excel as text , i cannot change it fom text to date. In fact I can't format it to any form at all. I guess I'll have to live with the default display . Unless any1 has other suggestions ? Appreciate the help Thanks :-) Gina

Hi , I have a linked ORACLE table in Access 2000 with a date "mydate" of type "Date/time" I have built a simple query which selects mydate. the query output shows as mydate as e.g. "6/23/1997" 1. If I export this query to Excel using "output to" in a macro the same date is displayed as...

Thanks so much ! That worked perfectly :-) The table is a linked ORACLE Table. and the field Datatype as seen in Access Table Design View is "Date/Time". I will make sure I post a new topic next time. I was thinking that any1 doing a search would find all related info under one post. But your...

Hi , I was trying to truncate the time part using Format (MyDatetime, "mm/dd/yyyy") or Format(MydateTime, "Short Date") But once i use format , the field loses it's date datatype and behaves as a string, so that if i sort asc 1/1/2003 appears before 12/31/2002. I want to be able to do a...

Sorry about that confusion. When I say B is a subset of A , I have applied criteria to table A to get selected records. The columns in both tables will remain the same, but the number of rows in B < number of rows in A The reason for creating this table is that : 1. The criteria is required...

Well, i use the field which i know is unique in the table. However in Access i have not explicitly defined it as a primary key. I had assumed that would be required only during updation. Why should a join fail if i don't define it that way ? Maybe I've not understood the concept correctly.

Vassago, My tables are linked so i can't post a sample,sorry about that. I'll try to explain. I deleted all tables in my database and relinked them using the save password option. A query I had created earlier now does not work. I ran the same query from the backup and it works fine. the only...

Hi , Can anyone help please ? i tried to delete all tables and relink using save password option. Now all my joins are acting up . would appreciate any suggestions . Thanks, Gina

I'm perplexed!! My joins are acting really strange. I have a linked table A . Using a maketable query and using some criteria , i have created a table B from table A . Both table A & B are exactly same in structure. If I use A instead of B in my query I lose data and i just can't understand...