Search results

It is my understanding that you can use a normal text box on the form, but in the table ensure you set the fields properties to "Memo," and not "Text". This will enable you to use more than 255 characters. Regards

A further related question for the Access Gods......... I am in a similar predicament, where I have two linked excel files which require refreshing in Access. My question is that is it possible, via VB or a macro, to automatocally run the Update Linked Tables function in Access, without having...

Keith P Many thanks - I hardwired the code into VB and has worked just great! Cheers

Hello All I currently have a form set up in which several textboxes autofill when a combobox (based on a query) option is selected, using the method of setting the textboxes properties control source as =[Vision Post Reference].column(2). This works fine on the form, however the info it pulls...

kh Many thanks for your reply. Users will be using Access to review, input and look at the data, and users will not have access to the source data. This data will have stuff like name, address, dob, which will be needed by the various different databases - I am trying to make duplication of...

Hello all I have been tasked with organising and developing some HR databases, where currently there are 8 or 9 different databases, all with duplicate personal info, but used for different issues - e.g. disciplinary, role details, attendance etc. I plan to merge and reduce this number to...

Further Question...... I have attempt to integrate the above "whoson" form into a db, but it does not work, and upon attempting to run it, it debugs to Private Function WhosOn() As String On Error GoTo Err_WhosOn Dim iLDBFile As Integer, iStart As...

Len Many many thanks, just what I was after! Regards

Hello Everyone I am designing a database, on which the main sheet is to hold many month's worth of data. I am setting up some queries to run against this, and instead of setting up various queries for each month, is there anyway that when a query is run, two prompt or input boxes appear, where...

Many thanks, sorted!

G'day everyone A rather rudimentary question, but has continued to confound me! I have got a form based upon a table, and all I want to do is to input numbers as decimals. Currently, whether, I enter the number in the table or in the form, it automatically rounds up or down the number to the...

Thanks very much for yuor time and help. I will look into the runtime option, as well as the Word Form article - many thanks Pat Regards

Thanks for the reply. To clear-up my understanding, by using the developers edition, I may be able to distribute the db to users who do not have Access on their PC?

Hello all Hope you may be able to help! Does anybody know if it is possible to have a form in MS Excel or Word, which one can use to search for and display data from an Access database? I cannot just use Excel, as Excel only supports 65k rows, and I have over £120K records - and sadly splitting...