Josh Andrews
Joined: Jun 9 '11
Location:
-
Thanks NeoPa, I somehow managed to get the script using yours as my guide. -
Hi, I was still coding/testing for two linked tables then place the results to the third table for reports. The following was my code (but still I get error messages for this, sometimes no error but wrong results):
...Code:UPDATE Area_Report SET MemberCount = (SELECT COUNT (*) FROM MemberTable WHERE SubArea = Area_table.Area_Code AND UpdateDate = DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)) FROM Area_Report INNER JOIN MemberTable
Last edited by NeoPa; Jan 10 '13, 04:22 AM. Reason: Please try to keep your replies to a single post unless there's a good reason otherwise.Leave a comment:
-
How to Count(*) certain records from multiple SQL table
Hi, how do I write this in sql script. I want to count the records from two or more joined tables and place the result in a new table. Attached is my tables. Thanks.
[IMGNOTHUMB]http://bytes.com/attachments/attachment/6809d1357733881/count_sql.jpg[/IMGNOTHUMB][IMGNOTHUMB]http://bytes.com/attachments/attachment/6814d1357788796/updated_tables. jpg[/IMGNOTHUMB]... -
Thanks NeoPa, I also tried that query. Do you think we can include the MAX word for that? I don't know how because I am just starting to script :-(Leave a comment:
-
Hi DaveRock, yes I need the last Ticket Number so that I can just increment the number (last four chars of the ticket num; "long" datatype) and use the same pattern. The problem is that I cannot just use the Select TOP 1 because the HASH PATTERN that I am trying to implement is slightly different from the previous months (I need to add characters to accomodate new records).
* REQ1111-0001 <--- my new HASH Ticket Number...Leave a comment:
-
SQL select query
Hi, I have an application that automates the Reference Number (or Ticket Number) for every new record encoded in the database in this pattern/hash:
REQ1111-0001
where: 'REQ' is a string (my prefix for request),
'11' - current year (4th & 5th char);
'11' - current month (6th & 7th char);
'-' dash (1 character; 8th place);
'0001' - number that increments every time a new record is added.
... -
TheSmileyCoder, I also used MS Access as my backend. What I did to the application is that when users archive their database, a copy (MS Access backend) is created and separates the archive from the live/current.
We have more than 10 users x 5 branches x (number of live and archive backend.
I think it's better to just send them a patch that will fix the linked tables. Please help....Leave a comment:
-
Josh Andrews started a topic How to change/alter datatype of a field from a linked table in MS Access?in AccessHow to change/alter datatype of a field from a linked table in MS Access?
Hi, I have created a MS Access database where all data are stored in linked tables. I noticed that two of my linked tables (parent and child in a subform) are having different datatypes: the first is set to AutoNumber (Long Integer) while the other one is Integer only. These tables are combined in my forms & reports, and in my queries.
Can I programmaticall y (VBA) change the datatype of my child table? and how?
... -
MailMerge:How to send one email to excel rows/records with same receipients (mailto)?
Hi all,
Is it possible to send ONLY one email with multiple rows/records from an excel file (please see attached image for reference)? For example, Bob borrowed three books (that means there are three rows/records with under Bob's) and when I tried using MailMerge, those records are sent as individual mails.
I have seen some solutions using MS Access but I do not want the excel files to be converted to database.... -
Hi Paul, I tried using Session.Abandon () but still users can navigate through the pages.Leave a comment:
-
yarbrough40 I also have this procedure:
[CODE]
Protected Sub imgLogOff_Click (ByVal sender As Object, ByVal e As System.Web.UI.I mageClickEventA rgs) Handles imgLogOff.Click
Session.Clear()
Session.Abandon ()
End Sub
[\CODE]Leave a comment:
-
Hi yarbrough40,
Login Method? Do you mean how do I connect to my database? I have an SQL db where the user profiles are stored. I use sql connection string (and sql data adapter) to check if users exist.
Log-off Method. I simply redirect them to my login page. My problem is that previous pages can still be navigated through even when the users are supposedly logged off the system :-(
I am a newbie in web development,...Leave a comment:
-
How to Expire a Webpage (VB.Net)
Hi all, I'm studying creating webpages in VB.Net. After a successful Logon, I want that page to expire or simple disallow users to 'go back' to that page (not necessarily disable the back button). I have created webpages under the Master Page.
Thanks in advance,
Josh -
How To Create/Declare Global Variable/s in VB.Net (Web Forms)
Hi all,
I am a newbie in VB.Net and was kind of lost in programming using it compared to the old VB6.
In VB6 I was able to create, declare or assign values to global variables. But now, it seems that every variable should be included in some class (I'm not sure).
What I need to do is to have some global variables and use them to different web pages without using the classes. What I mean is I do not like to use... -
Hi jpatchak, I tried them both, still there were no records displayed.
NeoPa, actually I really need to filter records with the "yyyy-mm" format. Though I changed your script, no records were displayed :-(
Should I change my approach on filtering data in forms?
Thanks jpatchak and NeoPa.Leave a comment:
-
How to Filter formatted Date fields in MS Access?
Hi,
I have a combobox named[listDateSelect] which allows users to filter records from my PrepareQuery table/query. The field[listDateSelect] has:
What I need is to format the [PrepareDate] with YYYY-MMCode:recordsource = "SELECT DISTINCT Format ([PrepareDate],"yyyy-mm") AS [YYYY-MM] FROM PrepareQuery ORDER BY Format([PrepareDate],"yyyy-mm") DESC"
...
No activity results to display
Leave a comment: