Search results

Yes Dave! I did the manual practice to insert a record until I reached to the acceptable number with one of my table, but this is a long process to go for every table to fix it as some table are really big and we have lot of tables in our database. I will try the madeg provided solution in the...

In addition to ghudson you should create a front-end/runtime application with all the codes removed or locked deign forms/reports with ACCDE/ACCDR extension for 2007 database.

I have an AutoNumber field in some table which is the primary key and refers to others table as foreign keys. I compact and repair 2007 with 2010 format and I got this problems with all the tables. the column's Seed property is below the maximum and it produce the previously issued...

This link http://allenbrowne.com/ser-40.html is really entrusting and the function which I read is near to solve the problem. I didn't try it yet. Thanks!

Thanks madEG! but its not the matter of how to reset the AutoNumber Key as your links says, the problem is i don't want to change or reset any ID as they are used as a reference in other tables as a foreign keys. If i change or reset it that would be a big mess. This problem is happened in...

Dear All, We recently upgrade all the computers in our office from 32bit to 64bit configuration. From - To Windows XP - Windows 7 Office 2007 - Office 2010 Our back-end database is in 2007 format, while front end we upgraded to 2010 format in order to make it compatible with 64bit...

Great! ghudson :) I found this one while googling for Audit trail, and it was from AWF and is your answer to somebody thread. its awesome. Thanks, I will try for it, you know I have a log table where I store users information their machine numbers, user names, time-out, time-in bla bla...

Hi! Two Questions! 1) Is it possible to create triggers in MS-Access? OR is it possible to record the system table's behaviour for insert,update and delete actions. 2) Is it possible to record the user's name/machine number if he/she made access to DATABASE window?

Hi lebowski! Welcome to Access World Forum, I think you want to create a database where you can record all the requests you receive from other departments and then you want to print reports (in your post forms). Next you want to know which reports is done "Completed" and which is "in-progress"...

Its true SOS, And also if your bound column and count column number of columns, are not properly defined in combo box then it will give you strange results in the list box or reports fields/columns.

This what I was thinking to suggest, :) ChrisO has given you the correct answer, SOS is right that there is no WHERE clause to use strCriteria in the DoCmd.OutputTo code. Good Luck to learn Ms-Access and VBA.

Its seems that your table has no record, its empty, to stop running the code if your recordset is blank i.e there is no record in the source table. Just add the following line in the code I wrote: If rs.RecordCount > 0 Then ' It check if your table has some records in it. ... ... ... End If...

Hi wongray! If you study the code I already posted earliar, that works exactly your requirement, only you have to add a code for Inserting and updating your new table "tb_Country_Combine". Anyhow, I added that one also just to insert and update your table: Here is the complete code: Sub...

Hi what is the idea behind this? This works fine in Ms-Access 2007. if you try this: If Me!subFrmSource.SourceObject = "Form2" Then Me!subFrmSource.SourceObject = "Form1" Else If Me!subFrmSource.SourceObject = "Form1" Then...

I know Banana :) I was just kidding. It's good that jon removed that nasty advertisers.

don't try to understand

Alas! so very are hijacked at last:o:mad::( I was very happy here sometime ago.

You are welcome, I hope you got that works!

Ahh naina! You are right, that's all you are using SQL server database :) I missed that. naina is also a good name, what does it mean BTW (is it beautiful eyes?):rolleyes:

Great! But you never said that you have adp with sql server data linked or may be i missed it, and if you remember, one of my post I mentioned that if you want such formats then your field should have a text data type ;) and which you have done at last. Glad you have sorted that out :)