Search results

In a Database table yes. The Calculated value has to be saved.

Dear all, Thank you for your replies. I am just providing a simple example of what I'm trying to do. I need to create a new field based on the values of fields in other data rows. I wanted to use Access to do this, and I was curious if there was a method available to do so. Hope that...

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

Thanks a bunch John! That works great!

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

I found the answer, I use the create query wizard and create an exclusion query!!! SUPER AWESOME!

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

Thank you for your help. I believed I solved the problem. The lesson is to never ever open up the backend and do stuff unless no one else is accessing the database.

Actually I have already split the databases and I'm still having this issue. Any advice is greatly appreciated!

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

I found the problem, I forgot a backslash! It should have been: strPath = "J:\AssemblyIssues\Hardcopies\" & Me!OrderNumber & ".pdf" Thank you very much!

Sean, Thank you very much for your post, it was extremely helpful. However, the below code does not work for me and I cannot understand why: Private Sub CmdViewHardcopy_Click() On Error GoTo HandleError Dim strPath As String strPath = "J:\AssemblyIssues\Hardcopies" &...

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

There should not be more than 6 choices in one case, in the others, there should not be more than 3 choices. On a similar note, is there a way such that as a user is typing, they see below them several suggestions for words. For example if I had a list of the following: Grand Canyon Grand...

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

Brian, Truly Truly Thank you. This has been bothering me all morning. I knew the solution was not that complicated! Sincerely, Bill

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

Sure, Private Sub txtProposedMix_AfterUpdate() On Error GoTo Err_cmdFirst_Click DoCmd.SetWarnings True Dim qryName As String Dim qryName2 As String Dim qryName3 As String Dim qryName4 As String Dim strQryName As String Dim strQryName2 As String Dim...

Dear Mike, I don't think there's anything incompatible with the Afterupdate event and my current code. If there's a way to properly call that function within the code, and if that would work that would be fine (I failed at calling the function). Thanks for your suggested code. I've tried...