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

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

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

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

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

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

OK I need to extract everything to the left of part of an address. For instance if the value for an address is "55 E Main St Unit 5" I need to remove everything to the left of "Unit 5" and put it into a new field "Address1". I am able to remove the "Unit 5" and place it into "Address 2" with...

How does one find a value (Like "Apt") in a field (say "Street Address") and put that value into another field ("Apartment")?

I cannot get DWCS4 to connect to my site by FTP. When trying to connect to ftp server I keep getting "an fpt error occured - cannot make connection to host" I can connect fine with Firezilla, what am I doing wrong?

Hello. I am trying to query a table to figure out which fields have a matching projectID but not a matching projectName and return the objectID of each incident. I have been attempting to use a self join to accomplish this but I keep getting errors stating that my columns are invalid. Here is my...

I am working on the following query to return results for records that are in the first table and not the second. I am fairly new to this so I am not sure where my mistake is, but I keep getting this syntax error. "Server: Msg 170, Level 15, State 1, Line 7 Line 7: Incorrect syntax near '.'."...

Is there are way to pull a field from a spreadsheet based on two criteria matches? I was trying to use the LOOKUP function, but I can only get it to work with one criteria. I really need to use two. Do I have an option to do this?

We have a word template that is used by multiple users. The template's macros seem to have stopped working on one user's computer while the others can still open the template with the macros popping up fine. The security settings for macros in word are set to low on the problem computer, and I...