Search results for query: *

Because you might be able to make it rounder ;-) Additional funtionality could include, importing multiple items at once, looping through records allowing you to amend and correct during the import procedure - I am sure there is more. I am sure others will agree that the existing wizard could...

Ok but I was wondering if there was any utility that had been developed to replicate the wizard, with Access forms etc. I have code to select files for import but these are specific to the format of those spreadsheets. Ideally I am looking for a generic utility that will read Excel...

Hi, I'm working for an organisation who have a quite stringent IT policy which effects ActiveX and in turn disables some the built in functionality of MS Office. I have got work arounds for most things I need - however I need to process a lot of spreadsheets of different sources through MS...

knew it was simple, thanks!

Hi I am simply trying to open a form with the following but I have tried all sorts and cannot get the syntax right. stLinkCriteria = [Exclude] <> 0 The Exclude is a yes/no as a tick box and all I want it to do is show all records with a tick - I would get round it by entering the criteria in...

There is no one else logged on - it is my frontend that is locking it - but I assumed that if I could get it to close all forms then this would unlock it. Even at the point of msgbox, I can see the code has closed all my forms but the .ldb for the backend is still resident,and so continuing...

Hi I obtained code to help me with this, but I cannot get it work as the backend database is locked when it tries to run the compact and repair. It will close all forms but the backend .ldb file is still resident while the code runs even after all forms are closed therefore moves to the error...

Hi I have a form that has a list of records with a button next to each for checking data linking criteria to another form. Once the user is happy with the data they return to the form and click a checkbox on that record. I have a release button at the top of the form that I want disabled until...

The Me did not work, but this information is useful and I have solved my problem. I instead referenced to a listbox control with the same value on the main form (that dictates the value on the subform). I realise I can refer to the value on the subform with the correct syntax, which is useful...

Hi Remou Yes the period is a numeric field so i removed the delimiters which solves some of the problem The click button is on a subform and I can get it to work correctly by referencing the form control like: forms![myform subform]![period] But this only works when the subform is open...

Hi can someone advise what is wrong with the following - I have fiddled with it and just cannot get it to work. Private Sub cmdViewTxns_Click() On Error GoTo Err_cmdViewTxns_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmKE5ZList"...

Duane, I thought it was only naughty crosstabs that required that old chestnut :) - problem solved - thanks very much! Remou, thanks for your help - I bet you're kicking yourself aswell :)

I have another append query doing this now aswell - reading the same control. I do get the type conversion failure warning with append and make table - I had warnings off before. It is a pain as I really need to log this information.

Surely if I had I would not get the value returned in the query preview? It appears that it reads it as a Binary value, tries to assign it to a text field in the destination table, and ultimately fails leaving it null. The fact that the make table query assigns the field as Binary indicates...

Form is open when running - I even have it visible now while I troubleshoot. Interestingly it does fail as a make table with a type conversion failure deleting those records - the new table has that field property set to "Binary" Why would it do this?

No import errors and it is just a text field - I just cannot work it out. I have another similar import that pulls the NetID info with no problems, except that does not calculate and lookup during the process. I have compared the SQL and table properties like for like and they are the same. It's...

I have an append query to populate a table from a couple of key reports in excel - it performs a few calculations and lookups during the import. Everything imports as it should but there is one field that does not get populated. The data shows on the query preview, but does not transfer to the...

Hi, I can find information to share calenders with Exchange accounts and publish online aswell as sending snapshots via email. Is there a way to simply share with other user profiles on a standalone machine running Vista? Thanks Richard

Hi I have a database to analyse financial data by month/period. I have a main data/transaction table (increasing by avg 20,000 records each month) which looks up various details from other tables and performs quite complex calculations to produce end of month reports for cost deferrals to the...

Perfect - thank you very much!