Recent content by glxman

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?