Search results for query: *

I open the report using a command button. I'm not so much familiar with writing WHERE statements in code. The three fields I am getting criteria from on the form that I may or may not want are [BySection], [ByTeam], and [ByHandler]. I want the user to be able to select all three, just the...

Not sure if this is why no one answered me, however I found that it works fine when I'm not in design mode of the database. If I just open it to use, it's perfect! Thanks!

I have a query to a report run from a "Report" form. The query is linked to the form for things like data range and other specific information that a user may like to view in the reports. If the user wants all the data in a date range, how can I omit the link/criteria for the other fields in...

Great idea. Continued.... http://www.tek-tips.com/viewthread.cfm?qid=1360032&page=1

This question actually began in another thread. To review: http://www.tek-tips.com/viewthread.cfm?qid=1359644 One more question. It's working slick right now except for one form in which I have it doing something OnCurrent. It seems to error out because the form has been closed due to the...

One more question. It's working slick right now except for one form in which I have it doing something OnCurrent. It seems to error out because the form has been closed due to the user (me in this case, testing) not having proper security enabled. I was thinking if putting code in the...

Perfect! Thanks to all. PHV that worked perfect using the code I had. How is one to ever figure that out? TheAceMan1 I am doing much better now. Thanks for your answer as well. I kind of figured out the creation and calling of a procedure, but your code confirmed it. Appreciate the...

Can you check this code as it is erroring out saying: "Run-time Error '2001': You cancelled the previous operation Can you tell me the error of my ways in the code below? Where should I put it (Form_Load, Form_Open, etc.?): Private Sub Form_Load() 'Checks User Security Dim UserName As...

Can you set an email to be sent out from Access automatically every Monday morning at 7am? I'm thinking no as one would have to have the Access application open as well as their email program for it to work. An Access with multiple users may just complicate the issue. Just thought I'd throw...

I so apologize, however the issue has been solved. The issue was in the query actually. I had to change the setting for Unique Values to Yes and all is good. Again, thanks so much for your assitance and accept my apology. Have a great Monday!!

It shows the record per employee in the multiple of the amount of units the manager has on the reports, in this specific case, 2 units or twice. We do not want the sum for the employee as it is only one record for the employee per report. I tired it, but the report still multiplies the data...

OK, hopefully I can make sense of this to you. The report is broken down and summarized by MANAGER, UNIT and EMPLOYEE. The data for the Detail section is simply a tally of occurrences. The MANAGER has a header and summed values in the footer section. The UNIT has a header and summed values in...

I'm thinking this is an easy one and I've figured it out before. Anyway, not today. I have a report that has a couple of headers and footers asssigned in the sorting & grouping section. It was set up originally using the wizard summing feature, but changes, of course, have arose. We are...

I tried some code that AfterUpdate for that field it took the whole number in the field, divided it by 100, and reinserted the decimal # in the field. Didn't work, but I think its the syntax not the idea that's hurting me here. Take a look: Dim Calculation Calculation = ([PercentCancelled] /...

Thanks for the response. Do you know how to correct this so the user only has to put in a whole number?

I have a field on a form where I am trying to enter a number that would be recorded as a percentage. In my table I have the field formatted as a percent. However, when I put in 25, for example, in my form, it records as 2500% instead of 25%. Seems like a no-brainer, but I can't figure it out...

I back. Thanks for your previous help. I have a new problem concerning the same issue. I got a query that gives me the next employee ID however my issue comes when more than one person is using the DB. I had it set up to populate the other fields once the Task field GotFocus. To avoid more...

Yes. It is bound to a table that will keep the data entered. The table has only 3 fields (tasknumber, ID, DateStamp). The [DateStamp] is kind of an AutoNumber that uses Now() for it's default value. This will assist in reporting later. I can sort decending on this value in a query to get...

The values are 4 characters long (ex. "A1XY") and I need it to select the next one after I use "A1XY" in the form to create a record. Example being maybe "ADVB" and the next few being selected from the list below in alphabetical order: CODF F678 F78B SI5K There will be hundreds of these...

I have a form of which will open and I want to auto populate a text box in the form with the "next" in line value/person. The values are in a table, ordered alphabetically. The twist added is that I have a yes/no field that will be "Yes" if the employee is in the office and of course "No" if...