Search results

Thank you very much for helping me with this problem it is now resolved. Kind regards, Eddie

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...

Many thanks for your help I've got it working now. Kind regards, Eddie

Can you show me how to write an XLM import specification in vb? kind regards, Eddie

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...

Hi Raheelwaseem, Thank you for the 'Last Friday Every Month' database you posted it is really useful. What I would like to ask you is, is possible to enter the last Friday information directly into fields in a table rather than into a list box? Kind regards, Eddie

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...

Hi Pbaldy, Many thanks for your help it's now working perfectly. Kind regards, Eddie

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...

Hi Kronk, Many thanks for your help, it is still not quite there but hopefully, when I come back refreshed from my two weeks holiday in Italy, it will be. Kind regards, Eddie

Hi Kronk, I really do appreciate the time that you've spent on this it must be as frustrating for you as it is for me. What I've done is to cut and paste the dbo_ODBC_ACCOUNT twice as a local table and then appended the data into them to ensure all three tables are identical. After completing...

Hi Cronk, Thanks for your help on this, the Union query is: SELECT dbo_ODBC_ACCOUNT.* FROM dbo_ODBC_ACCOUNT; union all SELECT tblHSCust.* FROM tblHSCust; UNION ALL SELECT tblNHCust.* FROM tblNHCust; Kind regards, Eddie Mason

Hi Cronk, Thanks for your help on this it's most frustrating. Firstly no it is not a Yes/No field, I have tried putting 'HS' into the query's criteria and when I opened the form it worked perfectly; flushed with this success I decided to create an unbound text box to hold the data that I...

Hi Cronk, I've done what you suggested but without any success same blank message box still appears. Kind regards, Eddie

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...

Many thanks for your help its been extremely useful. Kind regards, Eddie Mason

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

Hi CJ, Many thanks for the advice, I'm now up and running, you’ve been a great help. 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...