Search results

Okay, I'm back, though it's been a while, so hello to everyone, especially all of you who have helped me in the past. Retired, got out of the biz & haven't fooled w/Access for about a year, so it's like learning it all over again. I know I've done this before but lost the database I did it on...

I have an Orders form (frm-Orders) that includes a subform (frm-Order Details Subform). The subform has line item totals. I want to be able to sum the line item totals and show the result on the main form, but I can't get it to work. Seems like it should be an easy thing to do. Someone...

I've asked about this before but am still confused as to what to do. I am creating a customers and orders database for a client. This client has customers that are companies and customers that are individuals. Now, my method may be completely incorrect, but here's what I did: I created...

I am having a serious mental block when it comes to this. I know I've done it before, but I can't seem to find the old file to look at. Before responding, please keep in mind that I do not know VB, but can insert VB code when written for me (bad girl! bad girl!) So, here goes. I have a...

I am developing a Customers/Orders database for a client. Some of the customers will be companies with a contact name. Some will be individual customers. So---in the Customers table I have a field for Company, Contact, and Customer. In the Orders table, Company, Contact and Customer is...

I searched the forum and didn't see the answer to this. I am running a make-table macro. As is usual, the macro will ask the user to respond to certain things -- @ to run, existing table will be deleted, x number of rows will be pasted. Is there any way (without VB) to set the macro up to run...

I have searched through the forum but not yet found the answer I need for my issue. I'm sure there is something simple I'm missing here but.... I am developing a customers and orders database for a coffee sales company. I have, of course, a tblOrders that contains the fields 'OrderDate' and...

Stupid question with what I'm sure is an easy answer.... When I open my form in form view, how do I keep the right side from going all the way across my screen? I guess what I'm asking is is there a way to set the form size. I don't need my header color, etc going all the way across. Thanks!

This is a Customer Orders database created in Access 2010. tblProducts has field UnitPrice. I want the unit price to auto-fill based on product in tblOrderDetails. Seems simple enough, but I can't figure it out. I don't know VB other than inserting code someone else has created. Need to...

I'm trying to create a simple embedded macro for a checkbox control on a form [Company?]. The default value for this checkbox is No. I want to write an If statement that basically says "If[Company?] = Yes, then GotoControl[CompanyorNameCombo], Else GotoControl[CustomerFN] Although the...

I have a strange situation here that may be hard to explain. I have a Find Duplicates query that I created with the Query Wizard. IF I run the query and find duplicates, I can close the resultant datasheet with the close button. IF I run the query and find duplicates and delete them, I can...

I have done this in Excel before, but not Access. I do not know VBA. I figure this will have to be done in a query or a macro. I don't even know if all of this is possible in Access. I need to be able to split an Address field into: Street Number Street Name Street Type Street Direction And...

I have a macro created that has several different steps, some of which include Delete Queries and Append Queries. As is natural, when the Delete Queries or Append Queries run, the end user has to click an answer in a dialog box that pops up asking if they want to do it. The answer is always...

I have a form with a button that opens another form if certain conditions are met. I made a copy of that same form without altering anything, just copy and paste, but when I click that same button on the copy of the form, it asks for a parameter value. Doesn't do this on original form. I've...

Title doesn't make a lot of sense but here's the explanation. FRM-All Properties contains subform FRM-Client Offers. FRM-Client Offers contains a field named 'Offer Status' On After Update of 'Offer Status' I have created a macro with an If statement that tells it to open the FRM-Initiate...

How do I hide or disable the File tab in Access 2010 on my front ends? The file tab being present allows end user to get into Privacy Options and Printing. Printing is okay if I could disable the Privacy Options for end users, then it wouldn't matter if they have access to the File Tab...

I have a macro set to email a form to a person once a condition is met. This works fine but I've discovered that Outlook (2010) has to be open BEFORE this macro is invoked. I wanted to add a step to the macro before the one that makes it email that basically says to open Outlook. I have tried...

Is it possible (without using VB) to limit the number of selections a user can make in a multiple value list? My list is one a form and when in the form field it brings up a total of 15 names with checkboxes, allowing you to "check" each name you want. However, I want to be able to have as...

I am trying to write an IF statement as a macro on the OnClick property of a checkbox and can't get it to work, so I'm looking for help or even suggestions of a better way to accomplish this, if it can even be done. I don't see why it can't. Basically, if the checkbox is checked (for Yes) I...

I have a subformClientOffers on my frmAllProperties. On the subformClientOffers is a field called Outside Agents. This field allows for multiple values to be selected. The subfrmClientOffers is in datasheet view. While the field Outside Agents DOES allow me to select more than one, they...