Generating Special ID For New Record

Jan 6, 2006

Ok here is the next step i need to figure out :)

I need to have unique ID for each of my record in my form, and it should be created automatically.It should look like this:

AB060106-1
AB060106-2
AB060107-1
AB060107-2
AB060107-3
AB060108-1
and so on.

Idea is to have two or three letters at the front that never change, then 6 numbers that represent current date (year,month,day), and then incrementing numbers for that day.Whenever day changes, this last number starts from 1 up to 999 and next day it resets to 1 again.


Any ideas where should i start from? Thanks

View Replies


ADVERTISEMENT

Modules & VBA :: Generating Workbooks For Each Record In A Recordset?

Jul 18, 2013

Is is possible to generate a workbook for each record in a recordset, and title it using the unique identifier for that record?

I created the following code, but it does not seem to work. First of all it doesnt like the string and secondly it does not like the declaration of wb as Excel.Application

Code:
Private Sub generate_wkbk()
Dim rsID As DAO.Recordset
Set rsID = CurrentDb.OpenRecordset("Select * FROM tblMeeeting;", dbOpenDynaset)
With rsID
rsID.MoveFirst

[Code] .....

View 3 Replies View Related

General :: Create A New Record / Also Generating A New Auto Number

Dec 3, 2014

When I create a new record I am also generating a new Auto Number. This is so I have a sure fire way of returning the records that I want to return. I have read where it is a known issue that when using the Compact and Repair it can reset the Auto Number to a lower number and generate a duplicate Auto Number. That is the problem that I have at this time. I have tried using the Allen code but it doesn't seem to worked on linked tables. I use linked tables because I have multiple users who can access this system at any given point in time.how to have the Auto Number field select a number that is unique

View 12 Replies View Related

Forms :: Autonumber On Form - Automatic Generating New Record?

Oct 23, 2013

I am working on school project. I created priority table that has primary key (ID number) and other data, and three tables(also with data) that are linked to this table, with ID number of priority table and primary keys of other tables (relations many-to-many, I formed tables between them).

Problem: - my solution is created so that I can fill all neccessary data of ALL tables in ONE FORM. But ofcourse Access wants you to enter at least one field in primary table for opening new record, so that It links you to all other tables (in my case with ID number) - then It is possible to enter data of all other tables in whatever tab order you like.

What I want to do is that my autonumber field from primary table would automatically open a new record number when opening the form, without entering any data to primary table. Is that even possible ?

So far I tried to add another field in my primary table (Date/time format) and set the date to =Now(), and used macro of Refresh on form, but nothing happens. Date is shown in field, but Autonumber doesn't generate new number of record. maybe I did it wrong...

Any option to lock Tab order and force user to fullfill data only in desiring order ? I want to make solution more user friendly

I'm using Access 2003...

View 2 Replies View Related

Special Form

Dec 29, 2005

Hello,

I need your help.

in a budget application I'ma making, I have a table with all the budgets names, a table with the 12 months of the year, and a table with the budget, the months and the amount allocated for every budget topic for every month.

In order to facilitate the yearly view, i would like to build a special form that shows all the budgets for every month. Each column would be a diffetent month, the fist one being filled by the budget topics (a bit like an axecl sheet).

How can I build this form?

It is very helpfull for the application because it helps the user to fill the budgets month by month, but with keeping a yearly view (instead of having a long list of 3 columns, 1 for the budgets names, one fir the monthes, and one for the amounts).

Thanks in advance for your help.

View 6 Replies View Related

Special Characters

Jul 23, 2007

Hi guys,

I have a question regarding special characters that access doesn't like to see.

When passing a string to be absolved via html, if I set myHtmlBody = "<font color="#000FF"></font> it will throw a syntax error because of the # character.

How can I solve this? Thx for any help.

View 2 Replies View Related

Special Kind Of Calendar

Aug 28, 2006

Can anyone give me a direction for the following problem please :

I would like to create a yearcalendar that might do the following job for me:

I have 12 firms with different amounts of people working for them. We need to see those people once a year and give every firm an amount of days that they can come see us. Every firm may send 5 people each day but we can see up to two firms per day. So we receive 10 people on a daily base but only a max of 5 belonging to one firm.

I would like to have a means of automaticaly according dates to those firms over a period of one year but I must be able to exclude or instance, week-ends, holidays and so on...

I hope you can give me a start because I realy don't know where to begin

View 1 Replies View Related

F11 Special Key No Longer Working

Nov 7, 2006

I recently upgraded to Access XP (2002) and now my application will not respond to F11 to get into the development window. This application has two mdb files. One is the database (with security), and the other one has the forms, queries, reports and links to the tables in the first mdb.

View 12 Replies View Related

Replacing Special Characters

Feb 20, 2007

I am exporting an Access table as an xml file and need to be able to identify and replace '&', '(' and ')' as they are not accepted in xml.

Does anyone know how a query can be built which will find these characters in fields and update to ' and' or just remove?


Thanks

View 1 Replies View Related

Creating A Special Form

Aug 3, 2005

Okay I have a table with info about a computer and the usernames who can use this computer. Over the course of the day or week I have to add more users to this computer. I don't want to keep making a new record with the same computer information and only changing the usernames. I want to do it so I can go back to this form with the computer info. and username and click a button or something which allows me to add another user to the record. Essentially just adding another column. How would I do this? I'm pretty basic in Access so go easy on me.

View 1 Replies View Related

Help With Special Characters In Access

Jun 14, 2006

Hi,

I'm not sure whether i'm in the right forum or not but i'll tell you my problem and if i'm not you can point me in the right direction.

I have a form with a text area which allow's the user to submit a comment to an Access database.

I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

but this only seems to happen when the following characters are used " . / * : ! # & - ? " in the message.

Can the settings in Access be changed to correct this problem
or is it a coding problem??

Any help would be greatly appreciated.

Thxs dinivan

View 1 Replies View Related

Special Report I Need To Make

Jul 27, 2006

Hi, I'm running Microsoft access version 10 and i need help with a report i need to make. I need to print out a roster report showing what students show up on what days. I have boolean variables in the table for each day and it is quite easy to make a report of the students i want with the days of the week and a check under which day the student comes in. What I want however, instead of a check to show up under Monday (or any day) for the students, i want that students name to appear. So i teacher can just go down the list and on any given day see the students names very easily. when a student does not show up that day that row and column can just be blank

Here is a very crude sample of the report a have. a slash is a check

Monday Tuesday Wednesday
Jack / /
Brian /
Kelly / / /

Here would be the exact same report but formated the way i want it

Monday Tuesday Wednesday
Jack Jack Jack
Brian Brian
Kelly Kelly Kelly Kelly

thanks for any help.

Keith

View 1 Replies View Related

Modules & VBA :: How To Sum Up Special Column

Mar 6, 2014

Is it possible to tell VBA to sum up all columns with the column name containing a special string.

For example I want to sum up all columns containg 2013 as a column name.

View 3 Replies View Related

View And Print Special Characters

Feb 7, 2007

I faced a dilemma over the weekend in that I needed to preview and then print the ascii character 219 (A black block) on a report. It overlayed a paper calendar form that we use to print temporary access passes for where I work. The black blocks would indicate the days for the pass. Unfortunately, using Chr(219) did not work - so I searched the forums here and had a bit of luck, but still the solution remained elusive. Finally (and I should have done this first :)) I went to Help in access and found the answer.

To view or print any special character go to the start button on the computer, then navigate to programs, then accessories, then tools, then character map. Once there, choose whatever character you want and write down the Unicode number that applies. In my case, 2588. Convert that to decimal (Because it is in Hex) to 9608 and use an SQL statement Yourfield = ChrW(9608) to view or print it. The W is added to let the program know that this is a Unicode character and not ascii.

I read a lot of ingenious solutions in the forum, but this one seems to be the most straight forward.

View 4 Replies View Related

HELP! Special Help Creating A Date Query...

May 19, 2005

Here's my problem. We maintain a list of items that are sold on ebay. We keep track of all items purchased by individuals and the dates that those items were purchased. We guarantee shipping by 6 weeks after the sell date...

Therefore, I am trying to create a query that will show me all items that are 6 weeks and older and have not shipped. There is a column that says date purchased and one for date shipped if an item is already completed. Any suggestions!!??!?! :confused:

View 2 Replies View Related

Query Set-up With Special Column Headings

Nov 1, 2006

I have about 10 columns with data in each column...the columns dont need to show every time. I want to set it up where the user pics the column heading from a drop-down menu and then that column alone will show, none of the other columns are visible...can this be done?

View 1 Replies View Related

People's Names With Special Characters

Jul 31, 2006

My search has been unsuccessful due to the search function refusing to play nicely with me and the fact that it's mixing up the problems with using special characters with field names, which isn't what I want.

My problem is I have comboboxes that looks up people's name and has a NotInLIst event to allow addition of new person. It uses split function and concentating query to keep data normalized while displaying the full name.

Access trips over, very hard, whenever there is a name that uses special character, which for obvious reasons, causes confusion. Example:

Mike O'Leary
Thomas O'Calloway
Janet Smith-Johnson
Mary-Ann Johnson

Can anyone point me to a snippet I could use to trap for those names and help Access deal with it accordingly?

Thanks in advance.

View 2 Replies View Related

MS Access Update Query Special

Apr 25, 2007

Hi all,
I am generating a multi source concatenated code with an update query in Microsoft Access. I am wondering if there is a way to cut the update to only new entries rather than updating all records each time the query is run.

Any helpers for this problem?

View 2 Replies View Related

Modules & VBA :: Remove Special Characters

Feb 25, 2015

I have a Memo field that is used to be a description of a document. I don't know what the user will put in (could be anything), but it is eventually passed in a string to a query, etc.I discovered during testing that if an apostrophe is entered (Ex: This document explains how to deal with Joe's pleasant disposition.), it breaks my code. I then realized that all reserved words and characters would cause this problem.

I can get around this one just by using Replace(str, "'", "''"). However, I know there are others that will cause problems, and I don't want to end up with a string of replace statements just to fix them.

View 2 Replies View Related

How To Enter Special Character In Textbox

Jul 25, 2012

How to enter special character ' in textbox...

View 1 Replies View Related

Modules & VBA :: Display All Until A Special Character Is Found

Feb 3, 2014

L=Letter , X=number. Examples consisting of three parts (it can be more than three).

1. LLLLXXXXXX_LLLLXXXXXX_LLLLXXXXXX
OR
2. LLLLXXXXXX LLLLXXXXXX LLLLXXXXXX
OR
3. LLLLXXXXXX&LLLLXXXXXX&LLLLXXXXXX
OR
4. LLLL_LLLLXXXXXX&LLLLXXXXXX
OR
5. LL LLLLXXXXXX&LLLLXXXXXX

I would like to develop a function that takes a string that is made up of three parts or more and each part is separated by an underscore "_", space, or "&". There is no character that takes precedence over the other. It will always be only a single character which seperates the parts.

The check will always be done from the left. It should carry out the following actions:

1. Display all characters from the left until it reaches the first seperator "_" underscore OR "space" or "&"
2. Check only Part1 if it is made up of 4 letters and the rest 6 numbers (see 1-3 above). If that is the case only return part 1.
3. If part one only has letters and no numbers (see above 4-5) return all parts. Part one can consist of two letters or more.

I have started the function for step 1 above that searches for the character "_" underscore and display all characters until the first "_" is reached. I would like to include the same for "Space" or "&" in this function.

Once that is done I would like to do step 2 and step 3.

Code:
Function SearchforChar(strTest As String) As String
Dim test2 As String
Dim strUntil As String
strUntil = "_"
test2 = Left(strTest, InStr(1, strTest, strUntil) - 1)

[Code] ....

Answer3:
Full name with all parts should be returned for all above four cases under situation 3.

View 9 Replies View Related

General :: Coding A Button Special Function

Apr 23, 2015

I have created inventory databases for both my job and personal use. I do not understand coding. I either need a good hand-holding with simple, detailed instructions or I need to hire a code person.

A button in my form that can be coded to ... When clicked ...

___ open a browse window of hard drives,
___ allow user to choose any single image for selection,
___ copy & paste selected image's location to a table field.

NOTE: Table field will be used to connect to image place holder on form with control source to make the image seen.

View 8 Replies View Related

Queries :: Checking For Special Characters In Descriptions

Mar 12, 2015

I want my to detect special characters in my descriptions that are not found on keyboard and display as error.
Tried using the following

Description check: IIf([Common Description] Is Null Or [Common Description] Not Like "*[!a-z0-9@=.^_$%!#&'`(){|}*?~[]/-]*" And [Description Local] Is Null Or [Description Local] Not Like "*[!a-z0-9@=.^_$%!#&'`(){|}*?~[]/-]*","<<Error Desc>>","OK")

but when i tested it using some data, it shows all as <<Error Desc>>

some of the special characters i want to check for are βuΩ etc.

So if my description contains characters that are not: a-z OR 0-9 or any of the following ~!@#$%^&*()_+=-`][';/.,<>?:"{}|~

it will return <<Error Desc>>

View 4 Replies View Related

Modules & VBA :: Export To Special Table In Excel

Mar 19, 2014

the access database is about contracts.Each contract has an ID. So starting from ID1 to ID250. Right now i export in via VBA to excel. I have to create before in the excel the 250 tables. If the ID10 is not existing anymore i still have the table 10 left and then i have to delete this table.

Code:
Dim xlSheet As Object 'Excel.Worksheet
Dim rstID As DAO.Recordset, tmpStr As String
Dim rstGr As DAO.Recordset, strSQL As String

[code]....

View 3 Replies View Related

Modules & VBA :: Find And Replace Special Characters

Dec 18, 2013

I have a table called: "tb_special_characters" with a field name [character]. In this table are values that I would like to remove from fields in another table ("tb_data", field name [Title]

The values in the "tb_special_characters" are thinks like
.
@
}

I'd like to run a query on tb_data.title that would replace any matching characters in tb_special_characters.character with nothing (I remove and close any spaces).

View 2 Replies View Related

Forms :: Special Characters In Data Values

Aug 12, 2015

In my database there is one value that requires the use of a /. (This is not as a name of anything...just a value stored in one of the fields.) I have a form which functions beautifully in all other regards, but it produces an error about syntax of the subquery in the expression if I try to use this value as a criteria for a search/filter (screen shot of error message attached).

I've tried using double quotes and square brackets around the / and a in front of it to no avail. I don't have the option of changing the value...it is defined by this multi-billion dollar project. Again, this is just a piece of data in a field in a record which also needs to be a criteria in some searches/filters.

View 5 Replies View Related







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