Search results

One Million Thanks, Pat Hartman. This is not the first time you've made suggestions that have solved my challenges. This worked a treat! I really appreciate your help -- thanks again.

I tried Mile-O's suggestion, and that didn't work ... If I replace the ReportsTo with Surname as the Control Source, I get the same user's last name, not the manager's; when I try and concatenate it to include both, it fails (returns #name). The ReportsTo field gives me a value (a number) that...

Greetings All, I have an employee table that goes like this: tblEmployee EmpID Surname GivenName PositionNo ReportsTo The EmpID is a unique identifier; the position number (PositionNo) uniquely identifies a position, which an employee holds. With maternity leaves (and leave of other...

Thanks! That worked. More kudos for the forums, and thanks to the secretive dcx693 for the advice! In case anyone is interested, this is the actual code: Select Case Me.txtStatus Case Is = "Active" Me.fSubLoanedItems.Visible = False...

I have a text box on my main form that contains a value set from a value list. There are three possible values, and only values from the list can be used. Based on the values, I want to display a different subform as part of my main form, but I am not sure how to do this. For example, if my...

Can I get this to refresh, though? Hi, all. I was trying to do just this very thing! So kudos to the forum and the search tool. I have used the DLookup function to do exactly this - I return a value to the form (in this case the number of calls) in a text box, based on input from combo...

Cosmos75 & Vassago: Thanks a million for this advice. I paid heed, and reaped the dividends, as the solution is working perferctly. The only thing I did differently was capture the number of items to add in a parameter in the update query. I really appreciate the feedback, because the...

Thanks, Cosmos75! That's pretty cool, and it just might work. I am working in Access2000, but that's not a big deal. I am going to spend some time with this and see if it will meet my end-user needs -- I am actually creating totals from input forms (paper based) and entering the totals, so I...

Yes, the dreaded carriage return, but it shouldn't matter as long as your text is encapsulated in double quotes, and the receiving database is aware of that. Even if the data is manipulated in the csv file (which I assume it is not), as long as it remains in the double quotes, it should be...

This should work; I've done it mulitple times. The question to ask is, what is the database at National? When the data is exported, the memo field data should be enclosed in double quotes, like "Memo data". If this is being imported back to an Access database, I am very curious as to why it...

I'm not sure -- the input has been great, and thanks to everyone who responded. Just clarifying this for the forum has helped me thinking this through (not to mention staring at it all day!). Where I am now is still trying to minimize data entry. I have an operator table, a couple of "type"...

It might go something like this (it's from VB, but should be pretty similar to VBA - forgive me, I'm learning both) If Option1 = True Then SELECT [tblProducts].[ProductID], [tblProducts].[ProductName] FROM tblProducts ORDER BY [tblProducts].[ProductID]; End If ElseIf Option2 =...

You could add a radio button for the user to select the sort order, and then through code (If/Else or Case) launch the query with the appropriate sort order. More work for you, but transparent for the users.

So, I was trying to recreate the manual system.... you suggest not doing that, and just enter the date. In the data entry process, I have a log sheet for each operator, and enter in the number of calls received (CallsIn) and made (CallsOut). If I have use the week start/end date, then I enter...

To Cosmos Questions CallsIn (number) and CallsOut(number) are data entered from call log sheets. The statistics are purely sums of the CallsIn and CallsOut, so I can see how many calls the operators are processing. By collecting the data by Day in a separate Day table, am I making a) data...

Clarifying Sorry, I was trying to be clear ... failed. I am collecting statistics on calls. The statistics are collected daily, but reported weekly. That is, I may receive 7 calls on Monday, 15 Tuesday and so on, and on Friday afternoon I turn in my numbers to an admin person who updates the...

Greetings, I am building a database to track/log calls, and I need to collect daily statistics. I am looking/hoping for some insightful advice on how best to capture the daily stats. I am collecting information on three categories (calls, correspondence and on-call duty) for 5 days of the...

Can I write a procedure in a Class module that I can call from any form? What I am trying to do is create a button that I can set as active based on the state of a field. But I want to use this on all my forms! What I am trying to do is: If flag = True Then set btnSave.Visible = True Else...

Andy, using the wildcards in the parameter is pretty straightforward after you've done it once. For example, enter in your criteria field Like "*" & [Enter Your Parameter Stuff Here] & "*" This will give you a wildcard at beginning and end of the field. Is this what you're after? Then, when...

Yes, Jack is right. If you put all your subscription information in a Subscription table, link it using CustomerID to the Customer Table, then you can query the subscription based on the customer ID. If all the data is in one record, then do you have multiple entries for one customer? That'd...