Hi All, I wanted some help and advise on my existing database table structure and would appreciate some inputs to acheive normalization. currently i have 2...

I have a couple of questions that I hope someone can help with 1. I have the following criteria in a query I have created: =.. This works fine when the user...

I spiltted a database and put the back end on the server and the front end on the clients but when you open up the database up from one of the clients...

I have a report which I like to print which will show my y/n boxes with a nice little checkmark in it on screen. But when I print it, the whole column is...

please don't multipost. for more information, see http://home.att.net/~california.db/tips.html#aTip10 "mikeinohio" ...

found 5000 3d models at a pound each high def as well look at top right link at mdrepairs.com £1 each on cd images as well all very good

Hi, I have a field that shows only the month. I want to format it as a date so I can sort it by month, but the formating options for date all include the day...

I'm using MS Office 2007 Enterprise on Win XP Pro with all available updates. I can open and work with databases that I've created without any apparent...

Hi, I want to have a database to record all of my departments spending. I started to design my database but I keep coming up with problems so wondered if...

Hi folks, I have a database that pulls pricing data over from an AS400 for quotes. I want to be able to lock that data once the quote is accepted as the link...

Hi I got an error on this line: Dim objWord As Word.Application Compile Error: User-type not defined. Can anyone shed any light on this?

I have 3 tables: A, B and C. tblA contains a PK field "Name" which is joined to tblB and tblC as shown below... which works fine... tblA ...

Hello, I'm trying to update this movie database. The original was mostly a flat db, so I'm trying to do things the right way this time. Amongst other things,...

Does anyone know how to automate the backup process? Thanks.

I was given a table that I am redesigning. The orig table had a City text field and I added a popup City2 field that goes against a new Cities table. There...

I saw in some previous posts that a Memo field can be a cause of corruption because it is not actually stored in that given table, and that some people avoid...

Client has requested that if one user has started editing a record, then the record should become read only for all other users. Is this what is known as...

I had put a field name (FUPDate) in Table 1 but decided that this field need to be put in Table 2; so I deleted from T1 and put in T2. I never referenced...

Can anyone tell me what is wrong with this code. It falls with a "the open form command was canceled" error: Private Sub cmd_addDay_Click() On Error GoTo...

I have a database that I just can't visualize the relationships in. The data going in is made up of Company Contract Location etc. Each company may have...