Search results

Dear all, After putting in fields there were checkboxes into a Union Query, they now show up as -1s and 0s. Is a -1 a blank, and a 0 checked? Thanks, Bill

Dear all, I need a little assistance on creating a small loop to run code. This should be relatively simple, but I'm just not thinking of it properly. It should go something like this. For each record from AREA with PLANTPROGRAMID = VARIABLE Then (execute code here) Next record In this...

Dear all, I have form in which I modified the record source to include another table. Because I did that, the code no longer recognizes my combo box, Plant_Combo. See below. DoCmd.RunSQL "INSERT INTO Plant_Program (PlantID, ProgramID) VALUES (" & Me.Plant_Combo & "," & Me.ProgramID & ")"...

Dear all, I apologize for the thread. I have looked up similar threads, but am still having trouble. Any help would be appreciated. This VBA Code is being executed from Access. I am trying to make a code to check if an Excel workbook is open and if it is open, to close the workbook. The...

Dear all, I run a database for defect detail, tracking, and resolution. Often times we have the same type of defect occur multiple times before the problem is resolved. Currently the process is that every time a defect occurs, it gets entered into the database, and whenever it gets solved...

Dear all, I am trying to create a clean database and code to generate a report. Your assistance would be much appreciated. I am trying to count the number of null fields in one of my queries: However, because of this expression, I cannot carry other fields with it. So the end result looks...

Dear all, I have a database that consists of linked excel tables. I derive reports from these linked excel tables. I routinely have multiple people in my company open up these reports but only one person can be in there at a time; I would really like any number of users to be able to get in...

Dear all, I want to make a simple FrontEnd for my database for users to open reports to print them. I don't want them to mess with the linked tables or queries feeding into those reports. I want the front end to display a list of every report in the database that they can load up and use...

Dear all, I have a slightly complicated set of data that I have to be careful to correctly extract. Any help on making this simpler would be appreciated. I have a field called Claim # and another field called Month and another field called Quantity. A Claim will appear only 1 time in any...

Dear all, I'm trying to replicate a bit of Excel Code in Access, but for the moment I'm stumped. The above code refers to cells in other rows to get its values. Is there any way for Access to do something similarly? If so, how? :confused: Sincerely, Bill

Dear all, In my form, I have several users type in values. When my form opens by default it is like this: I would like it to be like this: By Default, Even though the Part # Textbox is the first Index Tab, the user currently has to hit tab or select that textbox with their mouse. How...

Dear all, I would like to be able to have a linked excel file in my Access Database, and then filter a query based on the values from that linked excel file. I can of course manually add to the query criteria, but I'm hoping that there's a more elegant solution. I have searched around but I...

Dear all, I have a continuous form which displays the results of my query. In my query I calculate the "Slack time" for an assembly line, or the time in which no one is working. Sometimes I will calculate a negative slack, meaning that they are working constantly and cannot be expected to...

Dear all, When another user on the intranet has my Access Database Open, I am unable to import data from my Access Database onto my Excel Spreadsheet. Is there a way to configure Access such that I can import the external data into excel and have another user editing the database? Any help...

Dear all, In my database, I am typing in the information present on a scanned pdf on my computer. However, I would like to create a command button that will open the pdf corresponding to my Primary Key. So basically, if I was on Record # 23, I would open up a PDF in my directory entitled...

Dear all, I have searched the internet and found several helpful threads such as the following below: However, none of them succinctly deal with the main issue I feel is important. I want the user to be able to type in a combo box an item in a predefined value list or click the down arrow...

Hi there. I'd like to get a certain result from HLOOKUP, but it seems unable to. For example take a look at the following Scenario and Code: The Code doesn't work because the Headings (option1, Option2, etc.) are in the first row and HLOOKUP requires that only values be in the first row...

Hi everyone, I am trying to solve the problem in Access 2003 of users wanting to type in a Percentage. I am aware of Allen Browne's tip to Enter a Value as a percent at http://www.allenbrowne.com/casu-16.html However, his example requires setting the Afterupdate Event to...

Hello All, My users have requested a complicated feature that I'm not exactly sure how to deliever. They would like to have the ability to make a copy of the current state of the database (i.e. all the values of the backend). And have a copy of the front end whose tables are linked to the...

I tried making a command button using Microsoft's default Command Button Maker to duplicate "Filter By Selection." I can Filter by Selection if I use the Toolbar. However, the Code from VBA does not work. The Code Microsoft imported is: DoCmd.DoMenuItem acFormBar, AcForm_View, 14, ...