Search results for query: *

I have looked at several posts and Thread 701-794191 is most applicable to my situation. The only thing that is does not address is when you have a name formatted as: O Donnell John. I want a first name, Last Name, Mid Initial columna and then I will need to reverse the order of the current...

Have a great form that I don't want to garbage up but now realize needs to be adjusted. When the customer calls in and we ask for the "ContractNum", we would expect him to give us the 9 digit number assigned to him. Once inut in the text box, subsequent text boxes will populate based on the...

Have a query built from a table and a query. I use this for a letter that is sent to customers in a membership file but the join is not correct and instead a creating a letter for each member, I can only get one member name to show up. All data types align and have tried different ways of...

I have what may seem like a silly question but could sure use an answer. In some of my databases, many of the reports look like a table and as such, I really like to use the Line/Border tool. Because a text box can grow, that outlined box is oten larger than the label box that is outlined. Is...

I would like to write code that would advide the user that the recordset is empty. The following code appears when the user opens my form that is built upon a member ship table (over 1000 members): Private Sub ContractNum_Enter() Private Sub Form_Open(Cancel As Integer) If...

I am looking for some help on writing a code. I have a form that is made based on a membership query. Upon entering a contract number in the first field, all other fields pertenent to the customer will populate (addr, city, state etc will appear. To accomplish this I am using an 'unbound' text...

I have a table that has several thousand records including that of a customer name. We are going to have to use mail merge to send out some monthly letters and I need a bit of formatting help on the name. The name field appears with last name first, space, and first name all in Caps (I.e. DOE...

I have what will seem like probably a dumb question but I have had very little experience with tab controls on a form. My data consists of a list of customers and their dependents, birthdates, etc. Below is an example of the primary fields on my table, and in the case of a family of 4, there...

I have a form with a list box that upon selection of an item, other fields with customer address information are populated. This works great using the following: Private Sub List18_Click() Dim szSQL As String Dim szContractNum As String szContractNum = Me.List18.Value szContractNum =...

I have a crosstab query that works great with the exception of 1 thing. When my Dec. 2005 data was imported, it did not update my December month. That still reads the 12/04 data. Can someone explain why this is happening? below is my SQL. TRANSFORM Max(ScoreWMSMo.EFFICIENCY) AS...

I am trying to hyperlink from an access form using a button to open another database on a different shared drive. The name of the folder that houses the database consists of 4 words with spaces and no underscore. Same is true with the mdb file within. As a result of some erros I incurred...

Have 12 month rolling crosstabs for 4 departments that work great as they have about 15 months data. A 5th department department began in July so there is not 12 months data. Is there anyway to format the report with the 12 months but perhaps show a 0 or leave blank until such time as there is...

Have 2 queries that I have combined as a 3rd query to use for a report. What happens is if I show the date parmeter of *2005* under weekending, I get only 2005 data. If I show the {Enter Begin Date} AND [Enter End Date] I do not get any data. What would be causing this? The date is formated...

I have a drop down box of 3 items listed for a field called "Workaround". The choices are Yes, No, NA. Originally I did the following but I get a "Complile error" when I try to click on any of the entries. Private Sub WorkAround_AfterUpdate() If IsNull(Me![Workaround]) Then Me![Workaround] =...

I have combine 3 queries and get correct numbers. when I add the 4th, it is way out of line. the two common fields on all 4 are Weekending and Ext. Below is the sql for the 3 queries with a seprate SQL for the 4th. Any help is appreciated. (3 queries) SELECT ScoreFatiqueWkly.Ext...

Have a form that opens when database is opened. Users will make appropriate entries and close. I would also like a button on the form for Reports but with user rights available only to leadership. Not sure how this is accomplished. Looked at different posts and the help files for access and...

I have a couple of questions if someone could answer them for me please. Courious minds need to know. I have one table (employees) with fields of LastName and FirstName. In my query, I use NAME: [LastName] & ", " & [FirstName] with a result of Doe,Jane. In another table (WMS)I have fields...

Have text files that import with a date field like 200509 or 200510. I have always changed the appearance to 2005/09 by using: WkDate: Left([Date],4) & "/" & Right([Date],2). Now I find I have to combine it with some other queries that have the date format of 10/20/2005. I have checked...

Have viewed several FAQ's on this subject as well as other forums and although the selection from cboTeam provides the appropriate list of employees in cboEmployee, the navigation arrows at the bottom of the form do not allow me to move to a new form for a new employee. A subform is used to...

Below is my SQL where I converted text to minutes/seconds. I thought that as a result of this I would be able to sum the totals of the minutes/seconds to get total minutes used. When I try to Sum on a separate query, I get the Data Type Mismatch in Criteria message. What might be missing...