Search results

I'm not sure if there is a function that would convert text months to numeric. If you find it use that, otherwise create your own using a Select Case statement. (you need the month in two digit format.) It will have the month and year as inputs. Inside the function, after the select case...

How do I run that? I assumed that it was supposed to be a query in the second db. Should I run it twice, or is it run some other way that it looks at both dbs?

1: SELECT MVADMP_LENDER.SELR_SRVR_NO AS [Lender Number], MVADMP_LENDER.NAME AS [Lender Name], MVADMP_STRUCTURED_FACILITY.DL_NME AS [CF Name], MVADMP_POOL.POOL_NO AS [Pool Number], MVADMP_POOL.SECU_FACE_VAL_AMT AS UPB, MVADMP_SECURITY.CUSIP_NO AS [CUSIP#]...

I have two database which are very similar. They both use the same back end table. I have a query that I developed in one db and it works correctly there. However, when I import it into the other db, I get the Ambiguous Outer Joins message. I've tried copying the SQL from one and pasting it into...

Well, you could create a query that puts the whole thing back together and looks like the original table and has the same name as the original table. It is looking for ProductID but the field names in the tables have a number in them, so it isn't finding the ProductID anywhere. What are these...

Won't SHIFT alone do it?

When you are joining tables (after you split a table into two, you need to join them in a query), you can have a one to one, one to many or a many to many relationship. (The many to many requires a third table with 2 one to many joins - Access cannot do a many do many directly). The most...

I think it will wrap, but I'm not sure. I think you can use DAO. Try it and see what happens.

You need to set the report's filter property to something like: "CustomerID = '" & SupID & "' and ItemID = '" &SupID2 & "'" If these IDs are numeric instead of text, eliminate the single quotes.

This should be very easy. In the OnOpen event dim HorPos as Long and use a series of If statements to check the values for null. After defaulting HorPos to the leftmost postion, check FieldA for null. If it is null set it's visible property to false. If it is not null set it's horizontal (left...

What is the nature of the info to be printed? If it is of a limited nature such as Reporting Month, you could open an InputBox in the OnOpen event and set whatever field is involved equal to the info coming back from the input box. If you have possible multiple entries, you could open a form in...

You could open a recordset and loop through the records and concatinate the contents.

I'm a little fuzzy about what you want. You say that you want to select people who appear in all three tables but then complain that you are getting results that match all three tables. If you join them on reporting person with outer joins and select distinct ReportingPerson where WR04 Is Not...

Try this as a start: 5 tables 1. Event table - info about event including category 2. Participants - info about participants including the info you mentioned 3. Table to join event table and participants (EventID and ParticipantID are included fields for linking) and any info that would apply to...

Well, let's say you have a table: EmployeeID LastName FirstName Address City State Zip Country DateOfBirth SocialSecurityNumber SecurityClearanceLevel ContactNumber NumberType In which you list, in ContactNumber, contact numbers such as home phone, office phone, home fax, office fax, home...

Right click on the database in the Windows Explorer and select Properties. Check that the "Read Only" checkbox is not checked.

The code before it checks for missing e-mails addresses and skips the step if it's missing. gemma seems to have hit the problem. I set it up his way and it works great. Yesterday, (I only saw gemma's response at about 10:00 EST today) I moved SendObject line and the error handler to a function...

Thanks gemma, It makes sense. Since I need to skip the table update if they cancel (records last date e-mail was sent), I guess I should create a flag in an If statement for the table update and have the error handler set the flag to prevent the update from running. (I checked Help for return...

Create a query selecting the item number an the date. Then set it up as an aggregate query, grouping on the item number and select the max date.

I have the following code: Do While Not rs.EOF If Not IsNull(rs!EMail) Then str = rs!EMail DoCmd.SetWarnings False DoCmd.SendObject acSendReport, rptstr, acFormatSNP, str, , , rsn!SbjLine rs.Edit...