Search results for query: *

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...

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...

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'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 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 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...

Can you disable Visual Basic Editor in Excel? I want to restrict users from viewing and/or modifying any macros. I'd like to diable the Tools / Macros on the toolbar and any shorcut keys that can be used to get into the VBE (Alt+F8 or Alt+F11). Thanks!

Good afternoon, I am working in an Excel workbook, of which should maybe be an Access DB, but my supervisor started with Excel and I'm helping him see how far we can push the envelope in Excel. I'm not sure he knows this. :) I have used the term Environ$("username") in Access to secure and...

Hello, I'm hoping someone can give me some insight here. This database began as a combination of 3 into 1. It has grown over the last year and its use and amount of users grows daily. Not sure what the limit is if there is any on the amount of users an Access DB can have. Anyway, we...

I have a database that I took over and I am in the process of improving and installing some error checking code in the "Before Update" sections to provide less missing and more consistent data. Below is the code I am having issues with. The field name is not a good one and to fix it correctly...

I have a query that I want to use an IIF statement return either specific data or all records depending on a text box value on a form. Basically the statemet reads as such: =IIf([Forms]![frm Reports by Type]![TaskType]="All",Null,[Forms]![frm Reports by Type]![TaskType]) It works fine as...

I have a database that appears to be somewhat unstable and I've tried to compact and repair it with no luck. It keeps erroring out and giving the check box option to close Access and reopen to repair the database. It's a viscious cycle that gets me no where and simple adds back-up files and DB...

Is it possible to omit certain data in a report that is in the query associated with the report? I know most would think for me to omit the data in the query, but I'm working on that in another post on here and until if and when I figure that out, this would be a work around. Thanks!

Can you set a field name to what is selected in a combo box on a form? This would cut my queries and reports I need to make down to about 1 or 2 from 30 to 100 I figure. Basically I have a table with 30 fields of information and I can get the use of a combo box, which lists all the table...

Hopefully I can describe this here. What I want to do is create a query/report that will retrieve data from specific table fields that I have selected using combo boxes in a Microsoft Access form. By doing this I can reduce all the reports I have to a minimum as most are exactly the same...

I am running a delete query and two append queries in my code. I get a warning message box both when the queries are deleting and going to add records to the table. The response on the users part will always be "Yes" which is the default answer that I can continue by hitting the enter key...

This should be a snap for someone out there. I am using a combo box in a form to lookup data I need retrieved. Thing is, right now after selecting the qualifying data in the combo box, you have to press "Shift + F9" to get it to update the rest of the form. Best way would be to code an...