Search results

I have a front-end database, “FinCode”, linked to a back-end database, “Finance”. Annually I make a copy of Finance, renaming it to Finance{year). Then delete the records in Finance. Occasionally I need to link to one of the old databases to check the historical data. If I forget to relink back...

Has anyone any experience using ODBC to link Xero Accounting Tables in Access? Hoping someone can help. Regards, Eddie

Can I update MySQL tables using Access? Regards Eddie

I hve just completed a form and I want to offer the user a choice to filter the data by Country, Diet and Date Last purchased before and after. I have managed to get it working using (Me.Filter = "Country like ""*" & Me.FilterField & "*"" And Diet Like ""*" & Me.FilterFieldA & "*"" ") for...

I'm having to purchase a new computer and I would like to know if I will have any issues running my legacy Access 2002 32 bit programmes on Access 2016 64 bit software. kind regards, Eddie

I have cribbed the following code from one of the ‘sample databases’ however what I would like it to do is to append ADate, AMonth and AYear into tblAppointments. Is there any way to achieve this? If Me.months > 0 Then Dim ad As Date Dim f1 As Double Dim f2 As Double Dim ADate As Date Dim...

I have a form (FormA) which contains two sub forms the first sub form (SubFormB) has a command button that runs an action which modifies data in a table. The second sub form (SubFormC) is a dynaset that has as its record source the data that has been modified. The command button works well...

I want to write an import specification that will import a XLM file into an Access table. I can import the file using 'External Data' 'import XLM file' which imports the table but does not allow me to save the import specification. Is there any way to save the specification or if this is not...

I have a problem when storing a calculated field with two decimal points. If I set the field to double, fixed, 2 decimal points. For the field it will show the calculations as: 21.364 as 21.36 21.563 as 21.56 21.272 as 21.27 Which is how I want it to be, however when I run a summary of the field...

I have modified one of the sample databases, "Last-Friday" to meet what I need. that is the second Tuesday in each month. What I would like to do and hope that someone can help me with is enter the list into a table. The line of code I want to enter into a table is: Me.List8.AddItem "Second...

I want to filter by two criteria: The first Is based on an ‘unbound combo box’ [DateNo] containing the numbers 1 – 31 and when I use the following code in isolation it works perfectly: Me.Filter = "DayNo = " & [DateNo] Me.FilterOn = True Me.Requery Using a second...

I have placed a filter button on a form as a filter and written the following on-click event procedure: DoCmd.SetWarnings False DoCmd.RunCommand acCmdApplyFilterSort Me.Filter = "ACCOUNT_DO_NOT_EMAIL = 'HS'" Me.FilterOn = True When I click the filter button I get a blank message box...

I have to confess that I am new to SQL Server linked tables so my knowledge is very limited, but when I first try to open a SQL linked table table it asks me for my password, is there anyway I can automate this process? Kind regards, Eddie

I have two tables both containing orders the first is an Access table with historic data and the second is a linked SQL table (which has replaced the old Access DB) with all the new orders. What I want to do is create a query which shows all the orders both old and new so that I can get various...

I am running a query from a form to export the selected records to a .csv file. This works perfectly except that I want it exported in UFT-8 format. Is there way that I can do this? The code that I am using is as follows: The fields appended to NewProducts are so that the query can be run...

Little more help: I was given the following function which works perfectly: - Public Function FieldLine(FName As String, TName As String, Separator As String) As String Dim Mydb As Database Dim Rst As Recordset Set Mydb = CurrentDb Set Rst = Mydb.OpenRecordset("SELECT " & FName...

I have a table with a field ‘Options’ that contains several records. What I want to do is to list the content of ‘Options’ into a single field separated by space. Eg: Options Small Medium Large To appear in a field as: Small Medium Large Options Small Medium Large Massive To appear in a...

I have a table with a field ‘Options’ that contains several records. What I want to do is list the content of ‘Options’ into a single field separated by space. Eg: Options Small Medium Large To appear in a field as: Small Medium Large Options Small Medium Large Massive To appear in...

I have set certain fields to have a red “Fore Color” to indicate to the user that these fields need updating. After the field has been updating I change its “Fore Color” from red to black to do this I have put the following code onto the fields “On Change Event”: Private Sub SKU_Change()...

I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records. This will...