Search results

Hope this is easy and I'm just overlooking the obvious. Scenario: I have one form that two groups of users use. One group edits the form; the other won't. Rather than writing code to disable all the controls, boxes...etc. on the form, I was hoping there was a way to "lock" the form when...

Hello All, Looking for some help. Scenario: User selects multiple values from a list box, selects a value from an unbound combo box and clicks submit. I would like to write the values selected from the list box into the table. The below code works for everything but the values selected...

Hello All, I know exactly where the code is failing but for some reason, I can't figure out the code. Scenario: I have filters on a form that will allow a user to find specific records. All filters work with the exception of the combo boxes that specify a date range. All combo boxes are...

Hello All, I'm hoping this is just an easy fix.... I found a thread that helped me put the code together to export my query into Excel. When I click the button, I receive a subscript out of range error. The sheet then opens but nothing has been imported. Any help would be greatly...

Hello. I've been searching through the threads and couldn't find anything related to my problem. Maybe I'm using the wrong search/key words? If someone knows of a thread, direct me to that as I do not want someone to duplicate work. What I would like to be able to do is update multiple...

Hello All, I've created a query that includes a date field (the field is formatted in the table as date/time). The idea is when the query is run it will only pull records that are 7 days before the current day, e.g., if the query is run on the 12th, it will only show records between the 12th...

I believe this is just a coding issue and that I'm overlooking something very basic. Scenario: I have an After Update function on a text box on a form that triggers an email. The VB code pulls information contained on the form and either puts it in the subject line, the TO field, and in the...

All, I have to imagine this can be done but I can't figure it out. Hopefully, someone in here can help me. I have a crosstob query with that returns 4 values: North, South, East, West. The query counts the number for each location, e.g., 4 in the South, 3 in the east...etc. This query...

Hope someone can help as my eyes are going cross... Scenario: Have multiple combo boxes (filters) that are triggered when a user runs a report. All work correctly. the ability to add a date range was requested. I searched this forum and found a link to allen browne's site. I added the...

Hope someone out there can help. I'm trying to open second form based on the criteria in the first. If I designate a single criteria, the second form opens without an issue. However, when I add a second criteria, i.e., using and, I can't get it to work. I'm hoping it's just a fundamental...

I checked the forum and couldn't find a specific reference to this problem. I have a form (with a few subforms) and some combo boxes at the top for filtering. Everything works fine with one exception. If a user selects criteria in the combo boxes and hits the filter button the form goes...

I'm pretty sure this can be done, but, for the life of me, I can't figure it out. I have a main form with 2 subforms. Process: 1. Filter the form to the account needed (works) 2. Enter in PO information on subform1 (works) 3. Apply the PO amounts to totals on subform 2 (works) Here's...

Hi All, After searching on here a bit and trying a few things on my own, I'm stuck. Scenario: I have a form for requisitions, which automatically pulls in the requisitioner's name based on their network ID. Luckily, the network ID is the same as the person's email address. (No problems...

I've been monkeying around with this for a while and can't figure out where the syntax error is. Maybe a set of fresh eyes can help. Scenario: Form with multiple combo boxes. A button on the form that when clicked, will open a report based on the values in the combobox. ComboBox1 lists...

Hello All, Not sure this is possible, however, I'll ask it anyway. I've created a form with several combo boxes which will act as filters on a report, i.e., AccountCmbo, StateCmbo, ManagerCmbo. I also have a report whose first grouping is Account and another for State and a third for...

Hello All, I can not figure out why I'm getting a Type Mismatch error with the following code. Any help/insight is appreciated. If Condition then Val = ("Cmgr = '" & Me.[CMgr_cmbo] & "'") And ("Aname = '" & Me.AccountCmbo & "'") Else Do Something Else End If Val is a string...

Hello All, I know I've done this before and am pretty sure I have something small missing from the code. In the below code, only the first part of the IF statement is working, i.e., it evaluates the left of the AND statment and ignores the right. I've switched it round with the same results...

I've searched the threads and even tried to find the answer on the Internet. If I missed the solution, I apologize. I've been looking to the point where it has all know become mud. Here's what I want to do: [RDate] is a field on the form that essentially will be the request date. When a...

I know I can't assign a value to the primary key, however, can it I pass the value? (might be the same as assigning, I suppose) Here's the problem: I have a main form that a user will fill out (the form has tab control with several tabs). Once the user fills out the main form, I would like...

I'm having a bit of a block as I know I've done this before. I want to be able to open a form with certain fields hidden based on the user's selection. I have a form with a combo box that has several values from which to chose. If the user selects value a, code would read: If...