Search results

-------------------------------------------------------------------------------- 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.

I created a webform using asp.net2. It collects data in sql server 2005. Then I need to create some reports upon the data. At first, I think I can use sql server reporting services. But this way she can only pull read only reports. I think maybe later our staff may need to change some data or...

I'm trying to compare two tables, table 1 and table 2. to see what are matched usernames, and what are not matched. I use following screen to pull username in table 2 which are not in table 1, but I get no records. I know there are quite a few usernames in 2 not in 1, or in 1 not in 2. But...

cannot exit access I have the same problem with my macros, any solution? THanks

I tried to use report wizard to create a report first, I want to use the summary option button in the process, but I cannot find the summary option button. Any one has ideas? Thanks in advance

After I save the record, I would like to clear all the data in the form and allow use to add another new record. I use code like me.mycontrol.myfield=null, it sets all text box to null, but the selectedlist box still filled in. The only way is to close the form and reopen the form. I have some...