Search results

Thanks, I will give this a shot and let you know how it works out.

I am trying to come up with a good, clean and efficient way to solve a problem of mine. I have my main form that has a combo box that allows an associate to put a set of information in (a name) and then once they type it in, to hit a command button that pops up a second form for the contact...

This is either going to fall under the query section or the report section but since this pertains to my report I figured I would start here. I have my main_tbl that is setup with a relationship on the field AccountType with tbl_AccountType, so it will display the name rather than a number in...

I think I see what you want, and it would involve your query. ExpressionName: [field]&", "&[field2]&", "&[field3] ... and so on. Should output: Field, Field2, Field 3. This what you looking for?

I have a question regarding union queries, for the most part I understand them. You have to have the same amount of fields in both tables/queries, but what I do not know is do both tables/queries need to mimic each other 100%. For example I have 2 Queries, both match each other identically in...

I am not sure if this is even possible, and I am almost positive it is going to resort me to have to figure this out in VB but I am wanting to create a table of contents that also includes the page number. I want the number to automatically update to the correct page in case if it changes. Is...

I have similar issue as businessman and I am getting the same error, also it is not a popup. Private Sub AssociateInitialsBox_Dirty(Cancel As Integer) Dim aEmp As Variant aEmp = DLookup("RightsLevel", "Users", "UserID='" & Environ("username") & "'") If aEmp = 10 Then MsgBox "You Do...

Any reports on Access 2007 being better behaved on wireless networks?

We actually already use a startup form that I believe does what you stated. It pops open a form if it is a first timer user asking for initials, their initials is associated with ther WorkID number that is taken from their computer using the environ("username") code and places in the user table...

wikipedia has a good article on normalization.

I am trying to brainstorm and idea that I have to better improve my companies database security. Right now all we have is a passworded backend and user levels for each person who uses the database. 10 - default; 50 - supervisor; 100 - developer. I am wanting to create a function, that looks...

SELECT UCase(Users.UserName) AS Associate, Count(Users.UserName) AS Pending, Sum(IIf(Date()-[DateNotified]<16,1,0)) AS [0-15 Days], Sum(IIf(Date()-[DateNotified]>15 And Date()-[DateNotified]<31,1,0)) AS [16-30 Days], Sum(IIf(Date()-[DateNotified]>30 And Date()-[DateNotified]<46,1,0)) AS [31-45...

This is probably more easier than my brain is allowing it to be. I have 2 queries AccountsClosedToday_qry SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.IsActive) AS [Closed Today] FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID GROUP BY...

Sorry, took a stab without looking at the spreadsheet since I was at work. Glad you got it though.

Try seeing if this works FieldName: [Subject1]&[Subject2] -- this should combine both subjects into one. I am assuming this is what you wanted.

You rock! Thanks.

I am having a minor headache with a situation, I have a command button that opens a view of the report that will be printed. The problem is if someone creates a new record and hits the button it comes up blank. If I add me.requery before the DoCmd statement then it just restarts to the very...

I have it figured out now. Thanks.

Would your prefer just to have me paste the code, its an intranet site so I have no outside link to send you. CSS Code: - Let me know if you need the HTML as well. /* Basic Elements */ body { font-family: GM Sans Regular, Arial, Helvetica, sans-serif; font-size:10pt; color: #000000...

all my width attributes are in %. now the margin attributes are in pixel. Do I need to adjust that too?