Search results

Hi Friends! Anybody knows how to Disable X button on a Form with win64bit configuration (API call)? The following API call is not working with 64 bit. Option Explicit Private Declare Function GetSystemMenu Lib "user32" _ (ByVal hwnd As Long, _ ByVal bRevert As Long) As Long ...

Yes Agnieszka! see this In the following tblInvoice, InvoiceID is the Autonumber field (not in sorted order in this view) the last number is showing in this view is 4932 while there are 5757 records in this table. so the new number should be 5758. when you compact and repair the database it...

Welcome to AWF! bob! you can get the Admission there too ;)

Check your store procedure and the wild card in the pram if you are using any. I did not use any store procedure but it seems that wild card [%,?,*] etc in your pram is producing this error. These are quiet different in Ms-Access. Visit: Store Procedures wildcards MS-Access VS SQL Using the...

Your code looks like a WWF wrestling tag team championship :rolleyes: Just kidding. To learn how to create Procedures, Modules, variable and if conditions: visit :Introduction to Procedures and modules

Shery! your tables structures for Client and Matters are not fulfilling the required concept of Database Foreign and Primary keys and you should be also aware of the Relational Database Normalization. In your table tblClientMater the ClientID should be a foreign key to accept multiple...

Are you using Access 2010? If you delete the record with autonumber column, every version of Access is giving the next Autonumber id to its new record. i.e current AutoNumber 1001 you add new record 1002 you delete 1002 .... you add new record 1003 now your Autonumber sequence 1001 1003 ...

Welcome to AWF Diana, you join the best place to give help and be helped, you will find here lot of good and intellectual MVPs and good experience peoples. They alway feel pleasure to help others and discus each other problems. Everybody learns from others and their experience. I love database...

Yes Agnieszka! I noticed something special while compacting the database with 2010 format. The tables which were not sorted in ascending order by its autonumbers key in the datasheet, drops its seeding number to the last record autonumber in the datasheet. i.e autonumbers (not sorted order)...

Brain! Neilbees has already have some invoice data which he doubts is wrong entries. so he wants to catch those entries. The function will calculate the digits and if there any duplicates found, he can further investigate through out some other office records I believe, any how.

raskew thumbs up! This little function made Neilbees's life easy;) Neilbees! tell your coo-workers not to cheat next time and make all the invoices clear. Good Luck.

You are right bill! but we always think that we should do everything by programing and coding. There are lot of way to handle things in a simple way. I like your idea of transpose calculating, we can do that in excel quiet easily, copy all the invoice data from access to excel sheet and...

Good point PNGBill, but how to sum up transpose digits?

you are welcome shery! here are some coding in my database where I can get the next Work-Orders number for a specific Contract No. Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Set db = CurrentDb strSQL = "SELECT...

Hi Shery! Its not easy to generate automatically the next matter number for the specific client. you have to do some programmatically. considers these steps: Create a client ID in your client table create a client Mater ID in your matter table (this should be a text field) combined the client...

Thanks for reply, I just want to know where is the potential mess where the autonumber changes to the lowest number seeding in Ms-Access 2010 format. In 2007 and earlier versions I did not face this problem. I noticed something special while compacting the database with 2010 format. The...

Compacting and recovering of Access-2007 database with Access-2010 format gives ridicules results. The Auto numbers seeds drop below the next seed numbers and give duplicate error, no new record can be Added to the effected table. See this Thread...

you should create a public function/sub routine with the Public key word in general section of the class to call it from anywhere in your project. The sub routine with the Private key words in the form can only be called within the current form.

you should make your front end as accde before distributing to the end-users. accdb is the source database where users can go to design of your form and your VBA code modules. you should prevent the users to see your codes and modify it or form design with following steps to make your front end...

Thanks madEG! The function worked exactly what I was expecting. Its really great. It fixed the column's Seed's property to the current maximum number and a new record can be added now. One problem is still there, if you re-compact and repaired the database with the Ms access-2010 format, its...