Search results

Is it possible to snoop at your vba code for generating the report and its controls!I have also done that but find that labels expand themselves to the with of the caption even if I specify in code that they should be ?? Thanks

I could also create the link when needed using transfertext and then delete it afterwards (all in code)

Thanks for your interest! I want to link to it very much like a linked table so that I can almost query it e.g if I have a string , I can lookup that string down the first column and return the value of the next column along (or 2 or 3 columns along) I am using column to describe each comma...

I have seen much of the forum re csv etc but have not seen anything similar to my question! my csv looks like this (actual values substituted for ease!) xName,yName,zname hello,hi,bye good,better,worse 57,90,87 The first 'column' is always different -no duplicates I need from within access...

We've all seen those pop up calendars which allow one to select any date which inserts itself into a textbox. I would like to create one but for the Jewish (lunar) calendar.This is made up of months (usually 12 but sometimes 13). Each month is either 29 or 30 days. (10 months are fixed and 2 are...

That was a quick reply! I did try that but am not too sure how to process the querydef. I'll have to look for help on that Thanks again

In a library database, I have a sql string which builds itself up using many criteria on a form from a number of tables. This is then passed on as a recordsource of a report . All works fine. However I wish to create another report which counts the number of records in one specific field e.g...

Thanks yes that did it. Actually I realize one can now turn off autocorrect in the text box properties!Thanks again

if I type a word like corg'i in an unbound textbox and move to another control it automatically changes to corg'I. The i changes to I. This is only true when I open the db in access 2000. In Access 2003 it remains fine. Is this some silly autocorrect function which can't be gotten rid of or is...

Many thanks for these last two posts! They certainly will be used in future to perform tasks on the backend remotely as I still desire to do!

Its to save yourself time when going around to all your clients who have the old backend. You just run your utility file which you have built and all neccessary changes are made whilst you sit back! Anyway at least we got it going! Perseverance does pay off! Thanks for your interest

Thanks Keith Actually I've been working a whole afternoon on this problem. I devised the following Import the table into current db Do the additions using Alter Table sql export back to the original db (it overwrites the original table with the same name) I am happy to post my efforts if anyone...

Thanks for reply but I find it hard to believe it cannot be done! What about creating another table with the same fields, add on some more fields, copy over all data from the original table and then delete original table and rename the new one to the name of the deleted one. What sort of code...

I need to add on a field to a clients existing backend for a number of clients. I devised a small code in a new db to do this however since the tables are only linked to this new db, it is not permitting the ALTER TABLE statement. So how can I do it? Thanks

22 views and not a single reply????? :(

Could you specify how you did this please? I want the user to be able to specify delimiter and other parameters Thanks

I know that the parameters of transfertext can be based on an import/export specification which has been made manually. I would like to enable the user to specify parameters such as the delimiter by typing it in a textbox or selecting from combo. (there would be a default if nothing entered)...

I am running office 2003 but my file is 2000 format. I want to create an mde which works for office 2000 users. It will not let me convert the file to mde unless it is 2003 mdb format. I understand that so I therefore took the mdb (2000 format) and opened it with office2000, converted it to an...

One can't create a CREATE TABLE sql in the query builder, it has to be manually typed in!Its called a Data Definition query. I have overcome the problem by creating the table in the current db, copying it to the backend,deleting it from front end and then linking it to the current db. All this...

Can a CREATE TABLE sql create a table in a different file? More specifically I want to use it to Create a table in the backend and if yes how could one link to it? I know the table could be created, copied to a different db and then deleted but I was hoping there's syntax in the CREATE TABLE to...