Search results

Hi, I have used access before but lost touch. Need some help to get me started please. Forgive me for asking such an elementary question but I am stuck for more than 2 hours googling. any help would be most appreciated. I have two tables as below (tbl1 and tbl2). I need to create a report...

Hi, With the following code assembled from multiple sources online, I am attempting to download a specific folder in my Outlook Inbox (outlook 365) into my access table called "Email" (Access 2016). I get a Run time error '424' Object required on the line: If Items.UnRead Then What am I...

Hello, I have an Access Form (Access 2016) with a drop down box and a button. The After Update event of the dropdown box has the following code to populate the hyperlink address in the button: me.cmdbutton.hyperlinkaddress = "http address pointing to our sharepoint site" When i choose an...

Hi, I have about 100 text files of the following format: Name: John Doe Address: 123 Main Street Zip: 55555 Name: Jill Doe Address: 234 Clyborne Zip: 66666 I need to import all these text files into a Single Table in Access. Obviously, the table would look like this: Name Address...

Hi, I have a report as described in my attachment. The record source of this Report is a Query. There are 6 columns (col1 through col6) which are calculated values. The values of Col1 through Col6 vary between 0, 1 or N/A. I want to calculate the Percentage for each ID with the following...

Please find a Sample Database that I have attached for my problem. I have a form called "frmdata" that has a "commoditynum" field and two subforms - "sfrmrsoavail" (representing all Available RSO records) and "sfrmrsoselected" (representing all Selected RSO records) for a particular...

Hi...I have the following requirement: I have a table called "tblselectrso" with the following fields: stockno rso1 rso2 rso3 rso4 rso5 s1 1 3 s2 2 4 5 stockno is a text field and rso1 through rso5 is a Number...

Here is my requirement: I have a Table called "tblresource" that has two fields - Resource (Text) and ResourceDate (Date). Date format in tblresource goes like this: resource1 1/1/2005 resource2 2/2/2005 resource3 3/3/2005 resource4 4/4/2005 I have a form where I need to show the...

I have a form field whose value is as follows: =Nz(DSum("Capital","Capital_Act","DatePart('q', CVDate([Capital_Month] & ' 1')) = 1 And [projectid]=" & "'" & [projectid] & "'"),0) Since I am using Domain lookup function in this field, it takes considerable time for this field to get populated...

I have a form based on a lengthy SQL query. I have several controls in this form whose control Source has the following formula: =Nz(DSum("Capital","Capital_Act","DatePart('q', CVDate([Capital_Month] & ' 1')) = 1 And [projectid]=" & "'" & [projectid] & "'"),0) When I navigate from one record...

Hi - I am looking for some help understanding the instructions in the msdn article on how to pass a parameter from a DAP. Please refer to the article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_PassParam.asp I was able to follow the instructions until...

Hi, I am trying to run a pass through query from a simple report that I have. The Syntax for the Pass through Query is as follows: SELECT "Assigned-To-Individual+", "Case-ID+" FROM HPD_HelpDesk WHERE "Assigned-To-Group+" = 'TEST' AND "Status" IN ( 'ACCEPTED','ASSIGNED' ) I am able to...

This is my situation: I received an Access db from a co-worker complaining she was unable to modify contents of some of the tables in it. I offered to assist her on this. 1. When I opened it, I was unable to modify the contents of the Tables inside. 'Read Data' and 'Read Design' are the only...

How to transfer control value backward? I have a report with a control that is a calculated field. Lets call this field "b" I want to use the value of "b" in the next record for another control. Lets call this field "c" I want to assign c = b (Note that there are about 10 calculations done...

I am writing an Excel VBA code to connect to an Access db and execute an access query. After executing the query, I would like to display the result in the excel spreadsheet. I was successfully able to make the connection to the access db using the following code: Set db = OpenDatabase("file...

I need to design a report just like the scenario outlined in my Attachment below. Would someone be able to teach me how to do this please? Thanks.

I need to develop a calculated query based on values from next record in a single table. After searching the forum, I was able to find some posts that were similar to what I want but I am unable to understand / draw a parallel with my situation. Please look at the attachment to see what I...

Hi, I have two tables as follows: ___________________________ tableA: projectid capital 1 200 2 200 3 300 4 400 tableB: projectid capital 1 100 2 200 3 300 ____________________________ I want to create...

I have a basic design question that I am not sure how to address. I am trying to build a simple data entry database with a form to take input from the user, store the values in a table. Once the data is gathered into the table I want to use this table to print a report of each record (entered...

I need to call a procedure called "Enableall" from my VBA code in the form. This function is defined as follows: Sub enableall(bolenable as boolean, frm as Form) When I call this using the following method it works fine: enableall false, me However, if I need to substitute a variable, say...