Recent content by xcao

-------------------------------------------------------------------------------- I have a query basically is to delete all records from a table that exists in another table. but when run, I got an error: Cannot delete from specified table. Please help, the table is like this: DELETE...

I need to do some data manupalation for some staff. She wants to move part of the row data to column. So I imported it as a table into Access. It's a table that has multiple rows for one employee. I would like to combine them into one row. Please note is Not to move All rows into columns...

Thanks, this works perfectly.

Yes. But the form which has the close button is another form when click edit on the frmAllSoftware form

Hello, I used to have a Access 2003 database,now after I convert it to 2007, one of the button is not working. The button is a close button, it used to work like this: after close the button, the form will be closed and another form opened in background will be refreshed., and also the combo...

I have a macro that runs a bunch of queries. I'm using Access 2007, because of security, I found it's hard for me to automate the macro. I don't use Access quite often, my question is if Access a good tool to automate process, I only know autoexc macro can be automated, but it needs to open...

Thank you very much. It is very helpful

Does it apply to my case as in my previous message by using cross tab? I cannot figure out how. The site is string, not number, how to total

I have a crystal report like this: PersonID, Lastname, Site 12, Abbott, A 12, Abbott, B 12, Abbott, F 34, Smith, C 50, Olson, B 50, Olson, E Basically a person can be in one or more site. (usually one or at most 4 sites. We totally have 9 sites.) Now I would like to pull the report this way-...

This is for using the record for mail merge. Not for storage. But when I look at the link you provide, it seems it's different with my case

I have a table that has multiple rows for one employee. I would like to combine them into one row. For example EmployeeID, Firstname, Lastname, plan description, plan Category ID1, John, Smith, Delta dental, Single ID1, John Smith, Life insurance, Basic ID1, John Smith, Long term disablity...

I do have some experience using reporting in access. But for tables do I have to draw the table using lines?

I have a web form that collects data and insert into sql server 2005. Since our staff may need later change or enter data into database, so I creatred an Access database using oDBC connection to sql server. Then the main purpose is to create reports upon the data. at first I plan to use Access...

If I only want our staff to enter data, or read reports etc for the database, instead of table, view or stored procedure design, should I set it up in sql server? I don't think I can do it in Access? Is that correct? THanks

Thanks a lot.