Search results

That's funny stuff audrey!! :D

Hi, I recently had to reinstall A97. Now that I am finishing my database I get the "Not installable ISAM" error. I know how to resolve this problem but how can I prevent it from happening again? Can I write code in my database so that it looks for these drivers and instal them automatically...

Thank you ghudson ;)

Hi, I was wondering if it is possible to create an expiration date scheme for a demo database? Based on date, the file will be unusable after, say 30 days... Can this be done? Thank you.

Thank you Rich ;)

Hi, After reinstalling Access 97 and running my database, every piece of code that uses the function Chr() produces the error "Can't find project or library"; pressing "ok" takes me to the References window. What's going on? I tried to install all the references that are unchecked but some...

I see no date limit for posting so here are my 2 cents...

You could hard code your user names and passwords like if txtUser <> "Fred Flintstone" then 'code for no entry else 'code for entry end if ...you know, but this approach might prove difficult because it's hard to maintain, meaning that in the probable case where you need to enter a new...

I can't do it this way because data in my table may repeat "legaly" in other records' fields. If you care to take a look at the attached jpg of my table, you will notice that records ID# 4851 & 4852 are almost identical 'till we get to the "defect" field; then record 4853 is similar to 4852 in...

Hi, My table has big chance of getting identical-duplicated records thru an import method where the only difference betweenn the records would be the autonumber field. How can I filter out these records at the time of import if they already exist in the table? or How can I remove them once the...

Hi Sambo, The following code just shows a way to get Access to look for a particular record and then prompt the user to take action: '------------------------------------------------------------------ 'See if saving ticket number already exist Dim dbs As Database, rst As Recordset Dim...

Hi, I need a line of code where by pressing a button the database window pops up or becomes visible. The window is hiden (thru the startup property) when the database is opened. Thanks.

Got it! Both the TransferSpreadsheet method and the Microsoft articles worked like a charm. I just can't believe how relatively easy this things are. Thank you for all your help and patience.

Well, I was looking for a cheaper solution (book runs for $45) though I'll certainly look for an used copy. Now, if some one has the code readily available for posting will be much appreciated. Help was very usefull in explaining the Transfer method. I'll definitely will give that a try...

Yes, all Excel files are identical one-page-only files. By formating I mean making the Excel spread sheet compatible with my Access table (adding necessary columns, making the cells the same format as the table, etc). I got this far where, through code, I have been able to format the page but...

I have been searching the forum for some code that will help me import an Excel spread sheet into a table in my database, but no luck so far. What I want is for the user to be able to select the Excel file to be imported and then have Access format the spread sheet and then import all the...

Cold I have a copy of the code too? Hi, I have been searching the forum for a solution to this particular issue. Thru code I have been able to have access format the Excel file but have not been abel to import it. Could I have a copy of the code you both any_west and aziz rasul are talking...

Hi, When printing records arranged in rows and columns only the first row prints with the given format (font, fonts size, etc), the rest of the rows print in a different font, and size making the data cramp up with in the cell. I have tried different formats and the same happens all the time...