AccessHunter
Last Activity: Jun 24 '09, 02:20 AM
Joined: Nov 3 '07
Location:
-
Sorry if I didn't explain properly. I am trying to get a count of how many patients (HS01, HS02...etc) were in each month from 2004 till 2006. In my sample data above, HS01 was admitted on 11/30/2004 and discharged on 03/07/205, which means that person was in the system for the months of Nov 04, Dec 04, Jan 05, Feb 05 and Mar 05. So the counts for Nov 04, Dec 04, Jan 05, Feb 05 and Mar 05 will go up by 1. This is the way every record should be processed... -
Query to Count records by Month
Hi,
Please treat this as urgent.
I have a table that has the fields
AdmitNum, AdmitSeq, EntryDate, DischargeDate and values
HS01, 01, 11/30/2004, 03/07/2005.
I want to be able to count HS01 for the each of the months Nov 04, Dec 04, Jan 05, Feb 05 and Mar 05 since that person got admitted in Nov 04 and was in care till Mar 05. It will be great if this can be done thru Access Queries, but if that is complicated... -
Append and Update an access table importing from excel
Please advice me on this.
I need to create a new access database that will used to collect the employee hours from various locations. Every friday supervisors from various locations will be sending a spreadsheet that has the following fields;Agency ID,Name,In Date,Out Date, Feb1 week,Feb2 week..until Jun5 week.Data from these spreadsheets needs to be imported and appended/updated to a master table in the access database.You have to keep in... -
VBA code to Restrict Access to an access form
I am working on an access database wthat has a main form and other multiple forms. The main form has buttons that when clicked will take user to the respective forms. I want to restirct access to couple of forms so that only our admin will have access to it. Is it possible to do that using VB? Please help.
Thanks -
Help with FileDialog
Hi,
Below is the VB code I am using to let users select the folder they want to save a file.My problem is once user selects a folder, none of the files in that folder is displayed. I understand it is because I am using FileDialogFolde rPicker.
My question is, when user selects a folder, is there a way to show all existing files under that folder, and also let them save the new file in the same folder.
I want users to... -
Populate an unbound text box on report
Hi,
I have an access report whose control source is a table. The report is opened via vba code.There is also an unbound text box (named - PassedonParms) on the report. In the vba code I have a variable to store the parameters passed on to the table. On the report I want to display the value of this variable. For that, in my vba code I said, PassedonParms = Variable. Its not displaying anything. Please help
Thanks -
Import and only update data that is changed
Hi,
I am working on an access database that will be used to maintain all Network equipments.
It has 4-6 tables. Once the database is completed there will be a master copy and multiple user copies. Master copy will be in a server and user copies will be in tech staff's laptops.Tech staff go to different locations to perform pc support, they carry their laptops with them.When they come back to the main office they want to refresh... -
Missing: Microsoft Internet Transfer Control 6.0
Hi,
Please help.
I am not sure if this is the right place to post this question.
I was given a database that was created by a person who no longer works here.I am trying to inherit the access database he owned. So when I double click the access database (mdb) to run it give me an error saying the project contains a missing or broken reference to the file MSINET.OCX version 1.0. I have Microsoft Visual... -
Hi,
Thanks for the replies. Sorry if I confused you, ActiveAddress and ActiveSupplier is the same field.
ThanksLeave a comment:
-
Refresh data in a continous form
Hi,
I have a continous form that displays Name and Address of Suppliers.
In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table, "Primary Suppliers".
The combobox is for 'Active Address' with values 'Yes' and 'No'.Control source of the form is,
Select * from PrimarySupplier s where [ActiveSupplier]="Yes". I want the form to display only... -
Hi,
Thanks for the solution.
I created the GroupQuery1 as you explained, but the result I got is this
It grouped all the warehouse-1 records to one instead of like I said in my first post.Code:CASE LOC FACILITY 0029174 01 WAREHOUSE-1 0029174 01 STORE A 0029174 01 STORE B 0029174 01 STORE C
Please help.
Thanks.Leave a comment:
-
Group and Count records in a table
Hi,
I have a table with the type of data as below,
sorted as follows, Case (ascending), Loc (ascending) and Transaction Date (ascending).
...Code:CASE LOC TRANSACTION DATE FACILITY 0029174 01 20061025 STORE-A 0029174 01 20061102 WAREHOUSE-1 0029174 01 20061124 WAREHOUSE-1 0029174 01 20061221 WAREHOUSE-1 0029174 01 20080414 STORE-B
-
Find Previous Record
I have a query that has the following fields/data,
ID, Seq, EDate, TDate;
3228, 1, 6/30/2008, 8/7/2008
3228, 1, 6/30/2008, 6/18/2008
3228, 1, 6/30/2008, 3/22/2005
3228, 1, 6/30/2008, 3/21/2000
I need to find the record where TDate is < EDate by 12 months.
I am not sure how to read thru all the records and find out which one has a TDate that is 12 months less then EDate.
... -
SWITCH error
Hi,
I am trying to run the following query, is giving me an error saying "missing right paranthesis" on the line where the SWITCH is. I couldn't figure out error, please help. Please treat this a urgent.
Thanks
SELECT Unique (ETA.CLNT_ID),
TC.CLNT_FNAME,
TC.CLNT_LNAME,
TC.CLNT_DOB,
LG.GENDER_NAME,
RACE_NAME,... -
How do I do that?
ThanksLeave a comment:
-
DeCode in Column List
I am trying to run the query below and its giving me an error saying "single row subquery returns morethan one row". Is there an another way to do this?
I need Funding Source 17/18 as Yes/No column and Funding Source 28 as another Yes/No Column along with other coulmns.
PLease treat this as urgent.
Thanks.
SELECT Unique (ETA.CLNT_ID),
TC.CLNT_FNAME,
TC.CLNT_LNAME,... -
VBA code to save a text file
Hi,
I have written a code to display the Save As dialog box for my users, with a default file name. The code works and displays the dialog box with the default name. But when I click the Save button on the dialog box its not actually doing the saving. I am sure some of you might have faced the same issue, please help.
Thanks
Below is my code.
Dim dlgSaveAs As FileDialog
... -
Export Query result to txt file tab delimited
Hi,
I need to automate a process that would export a query to a text file, tab delimited. I know how to do it manually. Is there a way to automate the same?
Please treat this as urgent.
Thanks for the help. -
Copy an access database and all objects in it
Hi,
I am trying to find a way to copy an access database and all the objects in it.
I need to make a copy of an existing database and modify some tables for each Fiscal Year. The whole manual process invlolves 10-12 steps. I am trying to automate this process and for that the first thing I need is a fresh copy of the current database, which I am not sure how to create one using a VBA code.
Please help.
... -
Extract string from a text
Hi,
Please help as this is urgent.
I have the following data in a column. In the report I want to display them only with whatever is before the "-".
A SECOND DAY, INC.-FORMAT 4
A SECOND ADY, INC-VERSION 1
A SECOND DAY,INC.-VERSION 1
CLAIR FOUNDATION - OPTION 1
CLAIR FOUNDATION - OPTION 3
CLAIR FOUNDATION - OPTION 4
C.O.T.I.C. - GRADE 3
RACE D&FS...
No activity results to display
Leave a comment: