Search results

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

Yes, just now I did try to reinstall office and repair the errors. It works now. Only one thing I'm a little concerned is : Does the office developer software configuration or file affected by this?

Not a syntax problem No, I don't think so. I think it's the Access configuration or files problem. Because I open every database or create a new database, then tried to use the subform wizard, it gives the message. Please give me more advice Thanks

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

Thank you. Yes, it is an error message. It's like: Message1 microsoft access cannot append all the records in the append query. Access set 0 field to Null due to a type conversion failure, and it didn't add 1 record to the table due to key violations,.......... Do you want to run the query...

customize message Actually it is not an error message. It seems it is an informational message. It happens whenever there is a primary key violation. So although I have error handling code, but this is not an error. Any suggestions for avoiding this message but using my own message? Thanks

Ann Thanks all the help from everyone. It helps a lot.

customize message Actually it is not an error message. It seems it is an informational message. It happens whenever there is a primary key violation. So although I have error handling code, but this is not an error. Any suggestions for avoiding this message but using my own message? Thanks

I have a command button which generates password and append to userpass table. Because one user can only have one password, I set username as primary key in the table. So when somebody click generate password button, if the password already exists, it will show the message: cannot append...

I have a macro runs a module that will populate a table with passwords. I don't want anyelse run the macro or module, because it will overwrite all the username and passwords in the table. How can I set security to the module and macro? Thanks .

Thank you very much

Thank you very much. I wonder if the password will have a repetition. Do I need to write code to loop through the password table to check if it is the same with the new generated password, if same, then run generate password again. Thanks

How can I module that generates password. The passowrd should be 8 characters long, including small and capital letter and numbers? Thanks in advance