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

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

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

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

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

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

I'm creating an Access data entry form for computer installations. Basically the entry form will choose a software and license, then select one or more computers to install the software on. Then later we can create a report that can track what softwares are installed on the computers, or...

I would create a letter report that with two pages, the two pages don't have the same data source -query. Is there any way that I can use two data sources in one report, or merge report. Thanks

Hello, I would create a report for students demographic information. The report will be used as a letter, and send to parents. Like: Dear Parents: Here are your 3 children info: Student1 name, student2 name, student3 name. But in my query, I have one field called studentname,then I group...

help! corrupted database We have an database corrupted. This happened after I use Access compact and repair database wizard. After that, when I open the database, it gives error message: Record(s) cannot be read; no read permission on 'MSysAccessObjects'" I tried two ways: one is create a...

Today I want to use the subform wizard, it gives error message: ---------------------------------------------- Your code contains a syntax error, or a microsoft function you need is not available. If the syntax is correct check the control wizards subkey or the libraries key in the microsoft...

I have a form with two fields, one is registration num, the other is association name. If an invalid regNo is entered, I check it in the underlying table, if there is no record, a message box shown telling need to reenter a valid regno. My code set the focus back to the regno, but actually...

I would like to using upsizing wizard in Access 2000 to convert an Access database to a sql server database. When I ran the wizard, and hit next button it gives error message: overflow. Then I update office Office 2000 SP-3 according to ms site knowledge base article 272384, but still get...

I have a form with a button called generating password. Every time there is a new client registration, we will click the button and generate a password for the user. But for some reason the passwords have a lot of duplicates. I use random function, I guess there shouldn't be duplicates, but...

I have a from with subform. The subform is a continuous form having control source is a table. When we do data entry, sometimes after typing half the word of the first field, the current record switches order with previous record. And the previous order moves down to the current record...