Search results

Yes This is what I gave: =Sum(IIf([strProgram]="Primary" And [datApplication Date] Between Date() And Date()-7,0))

I tried both Count and sum. Thanks

Hello Guys, I am getting following Error Message when I am trying to Run the Report. This is the Code: =Count(IIf([strProgram]="Primary" And [datApplication Date] Between Date() And Date()-7,1)) Here I am giving two criteria. It is working fine when I am giving just 1 criteria (either...

Thanks let me deal with my Manager

In the Table which the users are going to access have more than 11,000 records and it will keep on day by day. What would be your suggestion? Save this Database in a SharePoint site or split the database (All 15 Users will be saving the Database in a Different Network Locations) and move the...

Hi, Yes this DB not splitted and the file size is 29 MB Thanks

Hello Guys, I have developed a database and it’s working fine. Database is located in a Network Drive. There will be 15 users using this Database from 4 different departments and the Network location which I saved this database is not accessible for all the 15 users. (I can’t move the file...

I think I solved this. Actually my Database was saved in a Network Drive and there were 8 Subfolders. When I moved my Access Database in to the Main Network Drive (e.g. M:\Database\Current Database) and put the following code, this work perfectly DoCmd.TransferSpreadsheet acImport...

I think I solved this. Actually my Database was saved in a Network Drive and there were 8 Subfolders. When I moved my Access Database in to the Main Network Drive (e.g. M:\Database\Current Database) and put the following code, this work perfectly DoCmd.TransferSpreadsheet acImport...

I solved this. Actually the database was saved in a Network Drive and there were 8 sub folders. When I moved my Access Database in to a Subfolder of a Parent folder (e.g. M:\Database\Current Database) it worked perfectly Thanks a lot for your time and efforts.

I solved this. Actually the database was saved in a Network Drive and there were 8 sub folders. When I moved my Access Database in to a Subfolder of a Parent folder (e.g. M:\Database\Current Database) it worked perfectly Thanks a lot for your time and efforts.

Hello guys, When I am copying my Table and pasting that Table with paste Option Structure and Data, I am getting an Error message like "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data". It is working perfectly when I am pasting this...

I guess there is some bug in my Database ;) I tried TransferSpreadsheet method and it was not working in my current Database (I have more than 44 Tables in this Database). But when I create a New Database and use DoCmd.Spreadsheet Method it worked. Copying and pasting data from Excel to...

Thanks a lot for your reply. I tried DoCmd.TransferSpreadhseet method. But unfortunately it was not working. Thank You

Thank You. As plog suggested, I have created a query based on tblTest and then in the criteria of the all fields I put "Is Null". So the query will return just the blank fields. Users will copy and paste data from Excel in to this Query and this data will reflect in the tblTest Table. Thanks a lot

Thanks a lot. This works Perfectly

Thanks a lot. I completely understand the Risk Factor. But there are more than 100 Entries per day and it may take 1 Full day to do this job when we are using Form Thanks

Hello guys, Is there any method to hide the Records in a Table on a Button click Event? When a user click on a command button a Table will open and user would be copying data from an Excel spreadsheet to Access Table. This is my Code: DoCmd.OpenTable "tblTest", acViewNormal, acEdit...

Hi, When I create a new database and a new table, this code is working perfectly. I am not sure what's wrong with my Existing Database and I need this in my Existing Database. Thanks

Sorry that was my mistake. I have changed LName in both Access Table and Excel. But getting still the same Error Fname - Short Text - Field Size 255 Lname - Short Text - Field Size 255 DoB - Date/Time - Format yyyy-mm-dd Thanks