Search results

I have a database that I rescently imported a lot of text. every time it imported the symbol (") it has altered the data by wrapping it with extra " eg drill bit 3/8" is now "drill bit 3/8"" There about 7000 of these little data corruptions so it is impractical to fix manually ( really big...

hello, I have a very large report ( more than 1000 pages) with picture of about 7000 items it . The items are all seperated into categories( about 100 categories) I have written a seperate report to generate a table of contents both reports work well, but i am sick of joining the two pdf...

I have solved the problem I simply upgraded it from access 2000 to access 2003 and the problem went away obviously an implementation problem in access2000

how about as you contruct the query in design mode The simple way is: testabc: [test] * 1 This is generating a new fieldname testabc by using an existing field from a variable [test] which would have come from a table or another query

not quite sure what u are saying..... Table A and Table B are related with a common field ...fine what kind of relationship (1 to many)? I suspect that what you may be trying to do is cascade the tables. when you look at table A, in the first column do you have a "+" sign if you enter any...

I have an unusual problem again, I need to split a database that has cascading tables. The problem is when i split the database, everything still works except I loose he "+" signs in the beginning of the table I have tracked that down to the table properties being set to [auto] my real...

Thanks very much for your reply, Forms Yes I do have the forms already in place, its just its so much quicker for me to use it this way, and i can manipulate data at ease. Table Properties I have done as you suggested, but not very successfully I have gone to the front end and edited the...

I have a little program which i have written. It records the history of cheques that a buisness accepts There are three tables one is customers a second for accounts and a third for chque details Each of the tables is link by a "one to many relationship" When I view the first two tables...

I would suggest that you might like to set up one table ( as you already have)It would contain the details for each employee. Another table with type of work or leave that they are on or work they are doing A third table could collect the data that you are trying to record eg Employee id...

thanks again the correct sollution, as you suggested, is Like "* *" Which i would not have guessed in a million years Thanks :)

Hello I have a small problem which i am sure somebody has come accross before. I have a comments field in a table somebody has been writing comments preffixed and suffixed with stars for example "*****hello world*******" I need to write a query to find thess string of stars "*****"...

Thanks Bob for your quick reply I have split the database and yes the problem has gone away. Thanks for your idea, I had considerered it earlier but guess i was sort of interestred in why. I guess the reason does not matter as long as the problem has gone Thanks again Geoff

Hello, I am having trouble opening a shared database (access2000) in a 6 machine network All other machines can open it, and share it properly...except me I cant open it at all unless i have exclusive access to the database once i have the file open on my computer ,then everybody can get...