Search results for query: *

My organization has a document that was created in Word 2003 (I think). We are moving toward everyone being upgraded to Office 2010, and are cleaning up documents/templates that will be needed afterward. One such document has been brought to my attention where there appears to be about 20 or...

Thanks Duane! That's it!! So it was the usage of single quote/ double quote that was causing the issue then?

I have a form that searches on just one field of a particular table. You type in the word in a text box and the closest match appears on the text box below. If the user wants to open that record, there is a command button that they push to close the current form and open another form with the...

I have a multi-user database environment where users are inputting free form data anyway they like. Some are using all caps, some don't capitalize at all, and others do. Problem is, when reports/labels, etc are printed out, this is an issue. I would like to force the value of these field to be...

I have a form where users enter/edit/view related information in tabs. Some of my tabs are behaving correctly, some or not. By this I mean, when the user is in the edit form for a record, and would like to add a detail found in a subform (within a tab) the item can be selected but not saved. I...

That was it guys! The cbo was bound to the wrong column in the query. Switched it to the correct field and voila, success! Many many thanks!! This place is awesome with helpful souls like you both! :)

dhookom, That was it! It was bound to the wrong column! Switched that, and it worked! Many thanks!!

Hi there. I have an issue with getting my form to open with the correct information after it the record is chosen on another form. The second form opens but with no record selected. When I check the source of the opened form, it seems to be picking the wrong data. (i.e. instead of name, it...

Thanks for the feedback! dhookom, I actually had the form to use the OpenArgs, but this worked like a charm after I removed the OpenArgs, thanks!

I have a list box on a form that I am hoping will allow users to select the record from the box and it will open another form displaying the details of that record. So far, I have been able to populate the list and get it to open the form I want it to successfully. The problem lies in linking...

I have a database with 3 address fields which vary very widely in the data each has in it. I need to parse this data out into separate fields, and perhaps concatenate them back into proper formats afterward. The goal is to clean up the addresses into a structured format. Prior to this, the...

For instance. If I copy something in Word and try to paste it inside a Publisher file, it pastes the last thing copied inside of publisher instead of the last thing copied in general. If I got to Notebook, it copies just fine. If I copy and past inside one of the programs, it works fine. It will...

I have a form that has 5 subforms in it. I have set the tab order to where it should easily tab to the next field in the correct order that data would be input into the database. Sometimes it tabs through perfectly. Others it goes straight to the last subform skipping all the others. Why does...

Well, I need to do something since the dates don't match. For instance: The Bill Date for two consecutive months is 11/3/09 and 12/3/09 respectively. In the details area, this prints out right. However in the group header that is using this field, the exact same field is printing 11/1/09 and...

I am having an issue with my report pulling a wrong date. The exact same field is being used as a group and then again in the detail. In the detail section it is pulling correctly. For some reason in the group section it is not. The values being pulled are not even the correct values. I was...

We have been using the following formula in our time sheets to calculate each day. =((HOUR(I22-F22))+(MINUTE(I22-F22))/60)+((HOUR(O22-L22))+(MINUTE(O22-L22))/60)+((HOUR(U22-R22))+(MINUTE(U22-R22))/60) Up to this point we have rounded up or down to the nearest quarter hour our "clock in" and...

Am at a loss...I was going through some old floppies, moving the data to my hard drive and one of the discs seemed to get stuck. So I closed everything down, but the system seemed to be slow so I rebooted. Since then, the floppy drive (A:\) has gone missing. If I got through run and type A:\ I...

What do you suggest instead of hard coding Duane?

Well, I have still been unable to get this to work. I verified the commas, and the opening and closing parenthesis, but I am getting a syntax error now. I renamed some of the columns for testing and to rule out issues with the naming conventions. This is the query as it stands now. UPDATE...

I have an formula that I am trying to convert from Excel to Access. I keep getting formatting error messages. Either that a decimal or parenthesis is out of place or something (text which isn't text) should be in quotes. It is a eye-crossing formula, but I would so appreciate some assistance or...