Search results

Hi guys, I have done data migration from Access to SQL server and the forms which are unbound work fine but the bound forms don't work ( no data gets saved down and pulled through ) As with Access backend , within bound forms automatically 'unique ref' gets stored within a field but now with...

Hi guys, I have been getting a very strange issue . My accdb works fine but when I make accde and run it (click on the button) then it gives 'expression on click' error message. I compiled my database but still the same issue . Any help will be much appreciated. Thanjks

Hi Guys, I got the database built in MS Access so both front-end and back-end are in MS Access . Now we have to migrate data from MS Access to sql server so we will be having MS Access frontend and sql server backend. I am facing few issues in this as below: 1. In MS access back-end, there...

I'm using outlook VBA and can't see any input mask option in properties for the textbox :(

How can I use input mask to allow 10 digits in a textbox? I just tried the below code which won't let users enter more than 10 digits but I want to show 10 underscores (input mask) Private Sub txtAccount1_Change() Static abort As Boolean Static c If abort Then: abort = False: Exit Sub...

Basically 10 underscores (_) should appear on the textbox and it shouldn't allow users to enter more than 10 digits. Thanks

I have written the following code and it works fine but is there any way we can display 10 under scores ( like input mask so the users will know they need to enter 10 digits??) Private Sub txtAccount1_Change() Static abort As Boolean Static c If abort Then: abort = False: Exit Sub...

Hi guys, I want an input box on the textbox so it will accept only 10 digits. It shouldn't allow users to enter less than or more than 10 digits. How can I achieve this using vba? Thanks

What about the code that is using old field names with spaces and queries which are referring to old field names ???

Hi Guys, I have a database built in MS Access so it has Access backend and Access frontend. Now we are thinking of converting Access backend to sql server. But there are few issues we are facing as below: 1. There are some tables in Access which has fields names with spaces in. So we will need...

I have written the following piece of code and it works great : Private Sub SaveAttachments(olItem As Object) Dim myParentFolder As Folder Dim myDestFolder As Outlook.Folder Set myParentFolder = olItem.Parent If myParentFolder = "Inbox" Then Set myDestFolder =...

I am looking for a way to find out the folder name where the selected email is and then move that selected item to the 'Completed' Folder within that folder. If there are 2 mail box folders which have 'Completed' folders (so same name of the subfolders within 2 mailboxes) then there should be...

Hi Guys I have written following code and it works fine if the 'Completed' folder is within My Inbox (Personnel folder) but in my outlook there are some other group folders as well so if I create 'Completed' folder within the group folder then the below code doesn't work. So I am looking for...

Hi Guys I write down the following code within Access module to get computer name and username . So for every new Access database I will need to write down the same code to retrieve computer name and user name. As we have now moved on to sql server so we are using Access frontend and sql...

Guys , I have another issue when adding a new record in a table. Actually the following code works fine when we have MS access backend as ActionPlanID is 'Autonumber' in MS access but when migrated to sql server the datatype is changed to 'int' and the following highlighted line of code gives a...

Thank you very much guys. it worked a treat :)

Another issue guys, when i try to run forms then getting runtime error 3622 "You must use the dbseechanges option with openrecordset ... in the following line of code: Set rs = CurrentDb.OpenRecordset("tblAbsence")

Thanks, I have found this code: Public Sub subChangeLinkedTableNames() Dim dbCurr As DAO.Database Dim tdfCurr As DAO.TableDef Set dbCurr = CurrentDb() For Each tdfCurr In dbCurr.TableDefs If Len(tdfCurr.Connect) > 0 Then If Left(tdfCurr.Name, 4) = "dbo_"...

Hi Guys I am using upsizing wizard for data migration. I tried to migrate tables from both Access backend to sql server and it worked a treat. After the tables got exported in sql server I linked those tables to Access frontend . But all the tables linked are starting with 'dbo.' So my Access...

I'm using Access 2010. how to use dependency checker?