Search results

Thanks so much RoyVidar, that worked!!!!!!!!! I dont have any idea how this happen, but i am glad i know how to fix it. I thought for a while i was struck with a virus. he he he Again thanks very much.

Has anyone used SQL Server 2005 Workgroup Edition? I have an SQL Server 2000 database that i need to move to a new server that has the 2005 Workgroup Edition. What is the easiest way to do this? All that need to move are the tables which are on the 2000 SQL server. The queries, forms and...

i tried that no change

My MS Word opens up with these wierd ruler settings, how do i get them back to normal settings? For example the margines are set in pts instead of inches and page width and height is also in pts not inches? Thanks in advance for any help

OK i put this code on the "On Format" of the detail section of the report and it works wonderfully (for that one field) but now they want this for all fields in the report that have a null value! Is there anyway i could have the report check all fields and if null value then the label is to be...

I believe that only works if there is no data for all fields in a report? I probably have 50 fields and i want to red fly just a few fields IF they are blank. So i thought i could tie the conditional formating to just those fields of interest but i couldn't get it to work. Then i thought i...

I would like either the label associated with the control to come up in red or a phrase in the control that would remind the employee that there is missing data; example "Please fill in this information". This is an employee information sheet that is filled out and would like to generate a...

I have this report that i need to have a field show up in Red when there is no data in it, i took a look at conditional formating but didn't see how i could use this for what i needed. Any suggestions?

We are using Access 2003. I have a multiple user group using an Access be and fe. Be is stored on network, fe on each users computer. My problem is that if more then one user tries to open the db, it will not let them in. Acts as if the database was set to open excusively but i checked and it...

Each customer has a unique ID and the data is being entered and edited in a subform. If a customer orders 75 items, there will be 75 rows. Each item ordered will have a record in the subform. This is a proposal so often times the customers reviews it and then decides to order something else or...

I have a database that is tracking proposals and job orders. First the proposal goes out and then sometimes the customer what to change the order in some way which means i need to put a new row somewhere other then the end of the record. I know in Access you can not add a row in the middle of a...

didn't think about doing it that way but it will work, thanks

I have some yes/no fields that are unbound controls in a report. Is there any way to print these yes/no fields so they dont print as gray boxes without making them a bound control? I just need them for show on the report. thanks in advance for any suggestions.

Well i have to say that after leaving the db alone for a few hours really helped. I figured out that the only thing wrong was a stupid space in the command line! I had a space before the Letter D which represented the drive that the file is located. As soon as i took out the space it worked that...

I am trying to create a macro that will open up a mail merge letter from word that is tied to a table in access. I have done this before in previous versions of access but not in 2003. I am having a problem with the macro. It runs and doesn't return any error messages but it will not open the...

I want to use the transferdata option in the macros to automate import of excell spreadsheets but i want it to prompt the user to enter the excel spreadsheet. Because it will be a different file and location each time. I did a search but didn't come up with anything i could use. Any suggestions?

I have an excel spreadsheet that i have linked to an Access database. I need to append and delete records from the spreadsheet into an existing table in my Access database. I am able to append specific records from the spreadsheet into my table but then i want to delete the records from the...

I have a Order form that i would like to use combo boxes when adding details records to the order. For example, my list of products is very long, each product belongs to a Series(category) I would like to create two combo boxes when placing an order. First one to select series, then another...

THANKS SOOO MUCH!!!!!!!!!!!!! :) I also added an event procedure so it would work on deleted records. Ok now I owe you my life, cause I don't plan on having any more kids ;) Thanks again for all your help.

OK i will try to explain better. For every Job Order there can be many items purchased from more than one Mfg co. so the subform shows the different mfg co and the items related to them. There is a mfg subtotal on each mfg co. in the subform to the right. Then i have another subform bottom...