Automatic Sequencing - Can Access Do This?

Dec 7, 2007

Hi all,
We have a database here at work where we keep records of client marketing campaign materials, which lets us know when said materials have gone to print and such. The problem is that we've always had to type in the client info manually because none of us can seem to find a way to automatically update new client info in sequential order. We have to keep a list of the clients as well as the alphabetical code they've been assigned to, which has become very problematic, since everyone is not on the same page. I'll show you what I mean - below is an example of client names and the codes they've been assigned to:

(Existing client)Cleary - AFB

(New client) Greenville - AFC

(New client) UAW-DC - AFD

And so on....

If anyone could help me with this, I'd greatly appreciate it. Thanks for listening.

-Zoob

View Replies


ADVERTISEMENT

Peculiar Sequencing Problem

Apr 28, 2008

I have a kind of peculiar sequencing issue with a query. I have several machine designations:
A1
A2
A3
....
A10
A11
A13
B1
B2
etc.

but the last group is designated as right or left...in other words

C1R
C1L
C2R
C2L
...

I am trying to get the query to put them in order such that they appear as:

A1
A2
...
A10
A11
A12
A13
...
C1L
C1R
C2L
C2R

This requires breaking the first letter out, sequencing it and then doing the same for the other part(s). The first letter sequencing works fine but I can't seem to get the second part right. For the 1-13 designations, I am multiplying it by 1 in order to convert it to a number and thus make it sequence correctly. This worked before I had to add the R and L designations. Now it doesn't. Here is the statement I'm using for the second sequncing portion in the query:

IIf(Left([Machine],1)="C",Mid([Machine],2,2),Mid([Machine],2,2)*1)

It doesn't seem to convert the 1-13 over to numbers and is sequencing as if they are text, meaning it's coming out A1, A10, A11, A12, A13, A2, .... Is the query limited to one data type as an output to an expression or something?

View 6 Replies View Related

Incrementally Sequencing Two Alpha's In A Query

Jun 28, 2006

In a query I need the ability to cycle two alphabet characters in sequence. First pass is "AA", next is "AB" etc. After "AZ" it would cylce to "BA". After "ZZ" it would return to "AA" and repeat the sequence again. Any help would be greatly appreciated!

View 1 Replies View Related

Modules & VBA :: Auto-Number Sequencing By Compacting The Database

May 30, 2014

Lets say you have a table with an AutoNumber field.You populate it with 100 records.You delete the last 10 records (91-100)Now, I certainly know you can refresh the AutoNumber sequencing by compacting the database so the next record entered is 91.

My question is about NOT refreshing the AutoNumber sequencing.Lets say you DO NOT COMPACT and DO NOT refresh the AutoNumber Sequence.So, in that scenario, after deleting records 91-100 from the table, is there any programmatic way to determine that the next actual AutoNumber for that table will be 101?

View 3 Replies View Related

Modules & VBA :: Random Number Sequencing Based Off Of A Certain Criteria

Aug 21, 2013

I have a RN generator that looks at 9 different lanes and puts in a number based off of a certain criteria but I was wondering if in the frmLanes the actual "Go" button was an incoming number how could I get my current random number generator to look at that number and determine if the current number is within 5 of the "go" number?

Any way to have a beginning number that I would enter into a text box and have the number generator kick off based off of that number. I have included a copy of my db for viewing.

View 7 Replies View Related

Automatic Email From Access?

Jul 18, 2005

I have a table/form that has name, a specific date, and an email address. I would like that when the specified date matches the current date, it will automatically send an email to the address specified with a pre-built message. Is this possible? If so, how?

Thank you.

View 2 Replies View Related

Automatic Shutdown Of Access

Apr 26, 2006

Hi everyone,

Is there a way to automatically shut down Access after a given amount of time?

I have an Access application that runs across a network. Access is the front end of a SQL Server 2000 database.

Some of the users forget to close their application at night when they leave for the day. When I come in in the mornings, I like to run the Compact and Repair, but can't because someone is still logged in. So then I have to go to each and every computer to see if they are still logged in. By the time I vist each computer, the morning is almost started and people ARE logging in for the day.

So I'm hoping to find an application that will automatically either log each computer off across the network, or that will log the application off of each individual computer after a given amount of inactivity.

Thanks for your help...

View 2 Replies View Related

Access 07 -- Automatic Calculation Of Difference

Aug 7, 2007

Hi, I am creating a table in 07 and I want my table to be able to calculate the difference between two amounts. I have the column "price" which shows the total amount, another one called "money paid" which shows how much of the total amount they have paid so far and the third is "money owed" which is the difference that i want to be calculated automatically.
Do you know any way to do this??

View 5 Replies View Related

Forms :: Automatic Updation Of PPT In Access

Jun 26, 2015

I have an excel sheets with tables (Numbers). I have inserted this excel files into PPT. I have a button on my page. I have linked the PPT path to that buttom (using hyperlink). So, when I click the button the PPT which contains the excel charts is opening (this is good so far)The data in excel sheet is used by many people and they can change it.

When in Access the ppt is opened then it's showing the old data but not the new modified data. (We are right clicking on the ppt table and then updating the links)We just don't want to do that as we have lot of tables in PPT.when we open a ppt via access then it should automatically update itself in the backend and should open with the new values.

View 3 Replies View Related

Automatic Date And Time In Excel Or Access

Aug 13, 2005

How can I create a database which automaically inputs the date and time when a value is placed it another collumn.

e.g 3 collumns= name, date + time

When the name is inputted the present date and time are assigned to the name.

If the name is changed then the date and time are updated to the present.

Many Thanks.

J

View 2 Replies View Related

Modules & VBA :: Automatic Mail To Be Triggered From Access

Mar 11, 2015

I have a table in Access with a field End Date with couple of other fields like Company Name and Description associated with the End Date as one record. In other words, one record has fields Company Name, Description and End Date.how could I get Access trigger an email automatically to a set of people let's say a month before the End Date is approaching. If the End Date is 30/4/2015, I would need Access to be triggering an email to the recipients on 30/3/2015.

View 3 Replies View Related

Automatic Transfer Data From Access To Excel

Oct 7, 2014

I am working on an attendance file. I have created one MS access form and one excel sheet. On MS Access sheet I have Student ID, Date and Value. ON excel sheet I have Course, Student ID, NSN No and date.

I want data to be automatically appear on excel sheet from ms access form and after updating it or after transferring data i want these fields again empty and ready for next entry.

For example, If I type value .5 in ms access under 01-Jan-2014 for Student ID 1200001, value .5 should automatically appear in cell in ms excel sheet infront of same id (1200001) and under same date (01-jan-2014).

View 11 Replies View Related

Automatic Import Of Multiple CSV File In Access With Macro

Jan 11, 2012

I need to import 15 csv files into access every month. I have location of all those files listed in a table in the same access DB but i'm not sure how to incorporate them in a macro I have written to import one of those files:

Function Macro_TransferCsvFileTo_RatesTradeData()
On Error GoTo Macro_TransferCsvFileTo_RatesData_Err
DoCmd.TransferText acImportDelim, "Import_Spec_tbl_RatesData", "tbl_RatesData", "c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv", True, ""

[Code] ....

where c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv is the file name I want to be replaced by each of the file listed by me in the other access table.

View 3 Replies View Related

How To Send Automatic Reminder Email In MS Access 2010

Apr 1, 2014

I created a Tracking System and would like to send an automatic reminder to the person the ticket has been assigned to, using the due date and the text message in the field "reminder message". Once the message send, I want the database to recognize and not send it again. I want the database to send a new message if the due date has changed.

View 3 Replies View Related

Send Automatic Email Upon Receiving A Request In Access Through Outlook

Nov 11, 2014

I'm trying to use Access to send an automatic email reply upon receiving a request from a customer/employee, telling them that their request has been received and this is the tracking number and the due date of service completion. How can I do that? And I want it using Outlook because all the contacts are saved in Outlook and all emails sent and received through Outlook. And the version is Access 2010.

View 3 Replies View Related

Automatic Name Of Field When A Range Or Column Is Imported From Excel Into A Table In Access

Oct 9, 2014

When I import a column from Excel into a new table in Access using the Docmd.transferspreadsheet function, Access automatically assigns a field name of "F1"; and if I try to import a range of columns (Eg A1:B10), then Access saves them into a table with 2 columns with field names "F1" and "F2". The table is created as part of the Docmd function, and so I don't have control over the field names.

Is this going to always be the case? Can I depend on Access to always use this naming convention? Because I am about to start writing more code that will depend on these field names.

View 6 Replies View Related

General :: Automatic Backup Of Access Database With Date Added To End Of File Path

Jul 28, 2014

Just wanted to confirm which is the best way to create an automatic back up of a access DB. (Split DB, backing up the BE - Access2010)

Firstly I was thinking of just creating a batch file to copy the file to a new source directly with a task scheduler set up.

Ideally I'd like it to run daily and have the date of the back up added to the end of the filepath.

View 5 Replies View Related

Getting Non-Automatic ID To Become Automatic

Jun 11, 2013

I am in the process of development of a database and one of the functionality that I would like to achieve is a custom ID to become automatic on my 'ADD-CUSTOMER' form (e.g. CID0001 - CID0002) so on an so forth. From my research all I can see in access 2010 is a autonumber which cannot be altered (or at least i don't know how).

View 3 Replies View Related

Automatic Month

May 9, 2005

auto date no problem but just an automatic month ??


any ideas???

View 4 Replies View Related

Automatic Splitter!

Jul 28, 2005

I am tying to create a setup application in access. The setup forms are incorporated in the database application.It has to split my database into a FE and BE so that the corresponding files can be placed in thier corresponding files folders automatically.
Iam doing this because the database has to be exported to a number of remote locations every after two weeks.

Apart from using the Database Splitter, Could there be any Ideas on how i can split and link my database through code.

View 5 Replies View Related

Automatic AutoNumbering

Oct 2, 2005

I am using DMax function for my custom autonumber
I just realized that when using this in a multi user environment, I am getting duplications.
This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications”
My form also has a sub form, and when entering the sub form, the main record gets saved automatically.
First I added the following procedure

Private Sub Form_AfterInsert()
If IsNull(Me.OrderNo) Then
Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1
End If

Private Sub cmdSave_Click()
If IsNull(Me.OrderNo) Then
Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1
End If

However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen)

“DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert”

Now I moved the code to the “Form_BeforeUpdate” (still testing)

Does anyone have any experience on this problem?

Thank you

Joe

View 6 Replies View Related

Automatic Updates

Oct 23, 2006

Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy

View 1 Replies View Related

Automatic Renumbering

Aug 9, 2007

Our small newspaper needs to create a database of subscribers from which we can print labels in what the post office calls "Walk Sort" order, the order in which the mail carrier hand delivers the mail on his route. The number associated with a particular subscriber is not fixed because if another subscriber is added on that mail carriers route, it may fall between two existing entries. So the Walk Sort field needs to automatically renumber up or down when an entry is added or deleted. I will use that field to sort chronologically and print form feed labels.
I've figured out a way to do this in Excel, but I think Access might be a better program to use for this database. My question is, can Access automatically renumber a Walk Sort field if I add or remove entries? If so, how do I set it up to do that?
P.S. I haven't used Access for quite some time, and I wasn't very proficient with it then. :o

View 1 Replies View Related

Automatic Refresh

Dec 5, 2007

Hello everybody,

I have many front end's (using ACCESS 2007 runtime version) in different terminals. Suppose that from 'terminalA', I am assigning a task to an employee who's using 'terminalB'. The user is already looged on to the program by this time, so I want that 'task' to appear on his terminal without him having to press the 'Refresh' button (that I placed on the form) every time I give him a new task when he's logged on so he could see it. How would I do this?

Thank you very much.

View 3 Replies View Related

Automatic Date Qry

Jan 14, 2008

Hi,

i need to run a specific qry that runs from 5th to 5th of every month to show payments made between the dates. i dont want to fill anything in as these dates are set. can a qry be made to run and retrive the info between 5th of last month & 5th of current month automatically ( by the press of a button ) every month?

many thanks,


NS

View 3 Replies View Related

Automatic Lookup

Feb 24, 2005

hi i have two tables.

One with Item Data - ITem ID, Item Name and Item Value

On another table, i have transaction data - Transaction ID, Item 1, Item 1 Value, Item 2, Item 2 Value etc.

What i am looking for is a way of when i lookup item 1 and enter it, item 1 value will appear automatically.

Any ideas

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved