473,321 Members | 1,669 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Create New Record in Form

38
I'm triying to create a new record via a macro, like so:

MACRO NAME ACTION
CreateNewX : On Click Go To Record


Object Type : Form

Object Name: Is the name of the Form

Record: New

When i click on my 'Create New Record' button all the fields clear including my combo boxes, but when I go to put new values in the combo boxes and tab or hit return to move to the next field, the values disapear in the combo boxes and a record is not saved.


Help
Feb 14 '08 #1
33 3659
mshmyob
904 Expert 512MB
Are you adding a new record to the currently opened form.

if you are then leave out the Object Type and Object Name.

I'm triying to create a new record via a macro, like so:

MACRO NAME ACTION
CreateNewX : On Click Go To Record


Object Type : Form

Object Name: Is the name of the Form

Record: New

When i click on my 'Create New Record' button all the fields clear including my combo boxes, but when I go to put new values in the combo boxes and tab or hit return to move to the next field, the values disapear in the combo boxes and a record is not saved.


Help
Feb 14 '08 #2
Dev1
38
Are you adding a new record to the currently opened form.

if you are then leave out the Object Type and Object Name.
Thank you for your response. I did try that for both macros and the problem still exists. Any other thoughts?

-Dev1
Feb 14 '08 #3
Dev1
38
Thank you for your response. I did try that for both macros and the problem still exists. Any other thoughts?

-Dev1
One quesiton should I use 'Set Value' action? for the macros that I created for those two combo boxes?

-Dev1
Feb 14 '08 #4
mshmyob
904 Expert 512MB
Just to clarify. On your form you have text boxes AND combo boxes. Do the text fields save and only the combo boxes do not save?

What macro is behind the Combo boxes??

Are the controls bound?
Feb 14 '08 #5
Dev1
38
Just to clarify. On your form you have text boxes AND combo boxes. Do the text fields save and only the combo boxes do not save?

What macro is behind the Combo boxes??

Are the controls bound?
Yes, I have text boxes and combo boxes. Yes that is correct the text fields save and only the combo boxes do not save.

I eliminated the macros and use a event for NotInList:

Expand|Select|Wrap|Line Numbers
  1. Dim ctl As Control
  2.  
  3.     ' Return Control object that points to combo box.
  4.     Set ctl = Me!Combo83
  5.     ' Prompt user to verify they wish to add new value.
  6.     If MsgBox("Value is not in list. Add it?", _
  7.          vbOKCancel) = vbOK Then
  8.         ' Set Response argument to indicate that data
  9.         ' is being added.
  10.         Response = acDataErrAdded
  11.         ' Add string in NewData argument to row source.
  12.         ctl.RowSource = ctl.RowSource & ";" & NewData
  13.     Else
  14.     ' If user chooses Cancel, suppress error message
  15.     ' and undo changes.
  16.         Response = acDataErrContinue
  17.         ctl.Undo
  18.     End If
  19.  
I used this code for both of the combo box to save the new value but nothing is happening still. Oh, the combo box are not bound. I don't know how to do that yet, I'm researching that now.

Thank you for you quick response.

-Dev1
Feb 14 '08 #6
Dev1
38
Yes, I have text boxes and combo boxes. Yes that is correct the text fields save and only the combo boxes do not save.

I eliminated the macros and use a event for NotInList:

Dim ctl As Control

' Return Control object that points to combo box.
Set ctl = Me!Combo83
' Prompt user to verify they wish to add new value.
If MsgBox("Value is not in list. Add it?", _
vbOKCancel) = vbOK Then
' Set Response argument to indicate that data
' is being added.
Response = acDataErrAdded
' Add string in NewData argument to row source.
ctl.RowSource = ctl.RowSource & ";" & NewData
Else
' If user chooses Cancel, suppress error message
' and undo changes.
Response = acDataErrContinue
ctl.Undo
End If

I used this code for both of the combo box to save the new value but nothing is happening still. Oh, the combo box are not bound. I don't know how to do that yet, I'm researching that now.

Thank you for you quick response.

-Dev1

I did try to bind the combox to a column in the table:

Bound Column: Company

Company is a colum in my table. When I did that it started acting very weird. I should mention also that for the Row Source I have a query that is pulling values based on preceding combox, which the first combo box has a requery in it to pull values from the table.

-Dev1
Feb 14 '08 #7
mshmyob
904 Expert 512MB
Because the combo box is not bound it will not save in your table. The code you have below is used to TEMPORARILY save your ROWSOURCE.

When you open the form again the changes will be gone.

The procedure updates the list only for the current work session. You can’t permanently update the value list in Form view. The only way to accomplish that is to open the form in Design view, update the value list, and then save the form.

Yes, I have text boxes and combo boxes. Yes that is correct the text fields save and only the combo boxes do not save.

I eliminated the macros and use a event for NotInList:

Expand|Select|Wrap|Line Numbers
  1. Dim ctl As Control
  2.  
  3.     ' Return Control object that points to combo box.
  4.     Set ctl = Me!Combo83
  5.     ' Prompt user to verify they wish to add new value.
  6.     If MsgBox("Value is not in list. Add it?", _
  7.          vbOKCancel) = vbOK Then
  8.         ' Set Response argument to indicate that data
  9.         ' is being added.
  10.         Response = acDataErrAdded
  11.         ' Add string in NewData argument to row source.
  12.         ctl.RowSource = ctl.RowSource & ";" & NewData
  13.     Else
  14.     ' If user chooses Cancel, suppress error message
  15.     ' and undo changes.
  16.         Response = acDataErrContinue
  17.         ctl.Undo
  18.     End If
  19.  
I used this code for both of the combo box to save the new value but nothing is happening still. Oh, the combo box are not bound. I don't know how to do that yet, I'm researching that now.

Thank you for you quick response.

-Dev1
Feb 14 '08 #8
mshmyob
904 Expert 512MB
Weird??? A little more detail please.

Give me your settings for your 2 combo boxes.
I did try to bind the combox to a column in the table:

Bound Column: Company

Company is a colum in my table. When I did that it started acting very weird. I should mention also that for the Row Source I have a query that is pulling values based on preceding combox, which the first combo box has a requery in it to pull values from the table.

-Dev1
Feb 14 '08 #9
Dev1
38
Weird??? A little more detail please.

Give me your settings for your 2 combo boxes.
Sure,

The settings are

Combo box1:

Table/Query
SELECT [Sales Funnel1].[ASC Rep Reporting] FROM [Sales Funnel1] GROUP BY [Sales Funnel1].[ASC Rep Reporting] ORDER BY [Sales Funnel1].[ASC Rep Reporting];

Bound Column:1
Limit to list: No
Auto Expand: Yes

Event:
NotInList()

Dim ctl As Control

' Return Control object that points to combo box.
Set ctl = Me!Combo83
' Prompt user to verify they wish to add new value.
If MsgBox("Value is not in list. Add it?", _
vbOKCancel) = vbOK Then
' Set Response argument to indicate that data
' is being added.
Response = acDataErrAdded
' Add string in NewData argument to row source.
ctl.RowSource = ctl.RowSource & ";" & NewData
Else
' If user chooses Cancel, suppress error message
' and undo changes.
Response = acDataErrContinue
ctl.Undo
End If


Combo Box2

Table/Query
SELECT DISTINCT [Sales Funnel1].Company FROM [Sales Funnel1] WHERE ((([Sales Funnel1].[ASC Rep Reporting])=Forms!Opportunity!Combo83)) ORDER BY [Sales Funnel1].Company;

Bound Column:1
Limit to list: No
Auto Expand: Yes

Event: AfterUpdate()
Private Sub Combo81_AfterUpdate()
If IsNull(Me.Combo81) Then
Me.FilterOn = False
Else
Me.Filter = "Company= """ & Me.Combo81 & """"
Me.FilterOn = True
End If
End Sub

Event: NotINList()
Dim ctll As Control

' Return Control object that points to combo box.
Set ctll = Me!Combo81
' Prompt user to verify they wish to add new value.
If MsgBox("Value is not in list. Add it?", _
vbOKCancel) = vbOK Then
' Set Response argument to indicate that data
' is being added.
Response = acDataErrAdded
' Add string in NewData argument to row source.
ctll.RowSource = ctl.RowSource & ";" & NewData
Else
' If user chooses Cancel, suppress error message
' and undo changes.
Response = acDataErrContinue
ctll.Undo
End If


I have one table with about 8 columns. The two combo boxes are pulling value from this one table, 'Sales Funnel1'. The rest are text fields. What I'm trying to do is I have a Command Button to create a new record. For that i use a macro with the 'GoToRecord' Action. When I click the button all the fields clear including the comboxes. I use the above code to intercept the not in list error and allow the user to procede with adding a new value in both of the combo boxes. But when I tab or hit return after putting in a new value for both comb boxes the values are removed. Now I did test the other text fields to see if they are saving values and they are so that is good.

Thanks,

-Dev1
Feb 14 '08 #10
Dev1
38
Sure,

The settings are

Combo box1:

Table/Query
SELECT [Sales Funnel1].[ASC Rep Reporting] FROM [Sales Funnel1] GROUP BY [Sales Funnel1].[ASC Rep Reporting] ORDER BY [Sales Funnel1].[ASC Rep Reporting];

Bound Column:1
Limit to list: No
Auto Expand: Yes

Event:
NotInList()

Dim ctl As Control

' Return Control object that points to combo box.
Set ctl = Me!Combo83
' Prompt user to verify they wish to add new value.
If MsgBox("Value is not in list. Add it?", _
vbOKCancel) = vbOK Then
' Set Response argument to indicate that data
' is being added.
Response = acDataErrAdded
' Add string in NewData argument to row source.
ctl.RowSource = ctl.RowSource & ";" & NewData
Else
' If user chooses Cancel, suppress error message
' and undo changes.
Response = acDataErrContinue
ctl.Undo
End If


Combo Box2

Table/Query
SELECT DISTINCT [Sales Funnel1].Company FROM [Sales Funnel1] WHERE ((([Sales Funnel1].[ASC Rep Reporting])=Forms!Opportunity!Combo83)) ORDER BY [Sales Funnel1].Company;

Bound Column:1
Limit to list: No
Auto Expand: Yes

Event: AfterUpdate()
Private Sub Combo81_AfterUpdate()
If IsNull(Me.Combo81) Then
Me.FilterOn = False
Else
Me.Filter = "Company= """ & Me.Combo81 & """"
Me.FilterOn = True
End If
End Sub

Event: NotINList()
Dim ctll As Control

' Return Control object that points to combo box.
Set ctll = Me!Combo81
' Prompt user to verify they wish to add new value.
If MsgBox("Value is not in list. Add it?", _
vbOKCancel) = vbOK Then
' Set Response argument to indicate that data
' is being added.
Response = acDataErrAdded
' Add string in NewData argument to row source.
ctll.RowSource = ctl.RowSource & ";" & NewData
Else
' If user chooses Cancel, suppress error message
' and undo changes.
Response = acDataErrContinue
ctll.Undo
End If


I have one table with about 8 columns. The two combo boxes are pulling value from this one table, 'Sales Funnel1'. The rest are text fields. What I'm trying to do is I have a Command Button to create a new record. For that i use a macro with the 'GoToRecord' Action. When I click the button all the fields clear including the comboxes. I use the above code to intercept the not in list error and allow the user to procede with adding a new value in both of the combo boxes. But when I tab or hit return after putting in a new value for both comb boxes the values are removed. Now I did test the other text fields to see if they are saving values and they are so that is good.

Thanks,

-Dev1

mshmyob:

Any thoughts on what I provided?

-Dev1
Feb 14 '08 #11
Dev1
38
mshmyob:

Any thoughts on what I provided?

-Dev1

Can anyone help base on my second to the last post?
Feb 14 '08 #12
mshmyob
904 Expert 512MB
As I said erlier

Because the combo box is not bound it will not save in your table. The code you have below is used to TEMPORARILY save your ROWSOURCE.

When you open the form again the changes will be gone.

The procedure updates the list only for the current work session. You can’t permanently update the value list in Form view. The only way to accomplish that is to open the form in Design view, update the value list, and then save the form.

To get that to work properly you must set the LIMIT TO LIST = YES
You have it set to NO. Your value will then be saved to your table BUT when you close the form and open it again that value will NOT appear in your combo box as a choice. It will be in your table but not the combo box as a choice for future use.
Feb 14 '08 #13
Dev1
38
As I said erlier

Because the combo box is not bound it will not save in your table. The code you have below is used to TEMPORARILY save your ROWSOURCE.

When you open the form again the changes will be gone.

The procedure updates the list only for the current work session. You can’t permanently update the value list in Form view. The only way to accomplish that is to open the form in Design view, update the value list, and then save the form.

To get that to work properly you must set the LIMIT TO LIST = YES
You have it set to NO. Your value will then be saved to your table BUT when you close the form and open it again that value will NOT appear in your combo box as a choice. It will be in your table but not the combo box as a choice for future use.

Well obviously your first option is not a valid solution. That isn't even a practicle solution...

Thanks you for you help, but i really need a solution not critizim!

-Dev1
Feb 14 '08 #14
mshmyob
904 Expert 512MB
Nobody is criticizing. I am pointing out that to make your values save to your table you need to set the LIMIT TO LIST property = YES. Otherwise you NOT IN LIST event will never run.

But my point that the Row Source will keep clearing the next time you open the form still holds true.

I would try:

1. Make your control box bound to the field in your table
2. Set your Control Source to something like the following
SELECT DISTINCT Table1.tcboBox FROM Table1;
3. LIMIT TO LIST property = NO
4. ALLOW VALUE LIST EDITS property to YES

This will allow you to add values to your table which will appear in your combo box and if it not a primary key the DISTINCT word will eliminate duplicates from appearing in the combo box.


Well obviously your first option is not a valid solution. That isn't even a practicle solution...

Thanks you for you help, but i really need a solution not critizim!

-Dev1
Feb 14 '08 #15
Dev1
38
Nobody is criticizing. I am pointing out that to make your values save to your table you need to set the LIMIT TO LIST property = YES. Otherwise you NOT IN LIST event will never run.

But my point that the Row Source will keep clearing the next time you open the form still holds true.

I would try:

1. Make your control box bound to the field in your table
2. Set your Control Source to something like the following
SELECT DISTINCT Table1.tcboBox FROM Table1;
3. LIMIT TO LIST property = NO
4. ALLOW VALUE LIST EDITS property to YES

This will allow you to add values to your table which will appear in your combo box and if it not a primary key the DISTINCT word will eliminate duplicates from appearing in the combo box.
Thank you for the response! I'm becoming very fustrated and it's starting to show:).

Well If I understand you correctly the first combo box I have does the following:

Table/Query

SELECT [Sales Funnel1].[ASC Rep Reporting] FROM [Sales Funnel1] GROUP BY [Sales Funnel1].[ASC Rep Reporting] ORDER BY [Sales Funnel1].[ASC Rep Reporting];


Bound Column: 1
Limit to List: No
Auto Expand: Yes

The second combo box which is dependend on the first is:
Table/Query
SELECT DISTINCT [Sales Funnel1].Company FROM [Sales Funnel1] WHERE ((([Sales Funnel1].[ASC Rep Reporting])=Forms!Opportunity!Combo83)) ORDER BY [Sales Funnel1].Company;

"Comb83 bieng the above combobox"

Bound Column:1
Limit to List: Yes
Auto Expand: Yes.


As of right now the I can't save to either control like you indicated previously. If you could be a little more grainular that would be helpful. When you mention the steps above they are not detailed enough for my lack of knowing the Access Idea, which I do apoligize for!!!

-Dev1
Feb 14 '08 #16
mshmyob
904 Expert 512MB
I have made an attachment of a sample.

1. Two combo boxes
2. When you make a selection on the first the second gets populated based on the first combo box
3. All values get saved to the table
4. All new values are available for future use.


See if this helps any.

Thank you for the response! I'm becoming very fustrated and it's starting to show:).

Well If I understand you correctly the first combo box I have does the following:

Table/Query

SELECT [Sales Funnel1].[ASC Rep Reporting] FROM [Sales Funnel1] GROUP BY [Sales Funnel1].[ASC Rep Reporting] ORDER BY [Sales Funnel1].[ASC Rep Reporting];


Bound Column: 1
Limit to List: No
Auto Expand: Yes

The second combo box which is dependend on the first is:
Table/Query
SELECT DISTINCT [Sales Funnel1].Company FROM [Sales Funnel1] WHERE ((([Sales Funnel1].[ASC Rep Reporting])=Forms!Opportunity!Combo83)) ORDER BY [Sales Funnel1].Company;

"Comb83 bieng the above combobox"

Bound Column:1
Limit to List: Yes
Auto Expand: Yes.


As of right now the I can't save to either control like you indicated previously. If you could be a little more grainular that would be helpful. When you mention the steps above they are not detailed enough for my lack of knowing the Access Idea, which I do apoligize for!!!

-Dev1
Attached Files
File Type: zip combobox.zip (17.5 KB, 99 views)
Feb 15 '08 #17
Dev1
38
I have made an attachment of a sample.

1. Two combo boxes
2. When you make a selection on the first the second gets populated based on the first combo box
3. All values get saved to the table
4. All new values are available for future use.


See if this helps any.
How do you add attachments on this site? I don't see how you do it.

Thanks,

-Dev1
Attached Files
File Type: zip test.zip (621.6 KB, 96 views)
Feb 15 '08 #18
mshmyob
904 Expert 512MB
Yeah it took me awhile to figure it out also.

At the bottom of your post it says Edit/Delete. Select that and then you have a place to add an attachment.

But suprisingly you cannot delete your post (lol)

How do you add attachments on this site? I don't see how you do it.

Thanks,

-Dev1
Feb 15 '08 #19
Dev1
38
Yeah it took me awhile to figure it out also.

At the bottom of your post it says Edit/Delete. Select that and then you have a place to add an attachment.

But suprisingly you cannot delete your post (lol)

I added my MDB in the post just before this one, as an attachment. You will see the form. What you sent me as a example isnt quite what i was looking for. I have the dependent functinality working among the two combo boxes. When you open the mdb open the 'Opportunity' form and you will see ASC Rep Reporting and Company. Try to add a new value for each and watch what happens. I'm thinking I will have to make a new form just to add a new record to the table.

-Dev1
Feb 15 '08 #20
mshmyob
904 Expert 512MB
I have made a slight change to your file that allows your 2 fields to save.

The biggest problem you are having is that the design is not correct. You have 3 tables that are not related to each other and your main table is just 1 big table with massive amounts of redundancy.

You may want to consider doing a whole redesign and you won't have so much problems. Look at the following link
http://www.thescripts.com/forum/thread585228.html

Hope this helps.
Attached Files
File Type: zip test.zip (289.5 KB, 108 views)
Feb 15 '08 #21
Dev1
38
I have made a slight change to your file that allows your 2 fields to save.

The biggest problem you are having is that the design is not correct. You have 3 tables that are not related to each other and your main table is just 1 big table with massive amounts of redundancy.

You may want to consider doing a whole redesign and you won't have so much problems. Look at the following link
http://www.thescripts.com/forum/thread585228.html

Hope this helps.
mshmyob:

Yes I did get the file. Sorry for the late response, but I had to fufill my valentine obligations! I've just opened the file and looking to see where you made the changes.

Yes, yes you are correct about the design, horrible!! I know but when this assignment was given to me which was about 4 days ago, I've never touched Access before. Not make an excuse but the person who this was assgined to really didn't know how to build any solution and when I asked about the who what when and where they just needed something really quick. Which lead to the bad desgin. I wanted to go that route obvisouly but time would not permit.. not mine theres!!! I'm still digging into it. One thing I have noticed is that when you do add a new record you have to close the form in order for the new addition of the record to take effect. I'm looking to see if I can just add a save button. But it looks like that save functionality when add a value or record is done automaticly.

Thank you!!!!


-Dev1
Feb 15 '08 #22
mshmyob
904 Expert 512MB
No problem. I did redo it by the way to have you add a record because I noticed the problem with that when I was checking it for you. But I took out that code so you could try it on your own. (lol)

mshmyob:

Yes I did get the file. Sorry for the late response, but I had to fufill my valentine obligations! I've just opened the file and looking to see where you made the changes.

Yes, yes you are correct about the design, horrible!! I know but when this assignment was given to me which was about 4 days ago, I've never touched Access before. Not make an excuse but the person who this was assgined to really didn't know how to build any solution and when I asked about the who what when and where they just needed something really quick. Which lead to the bad desgin. I wanted to go that route obvisouly but time would not permit.. not mine theres!!! I'm still digging into it. One thing I have noticed is that when you do add a new record you have to close the form in order for the new addition of the record to take effect. I'm looking to see if I can just add a save button. But it looks like that save functionality when add a value or record is done automaticly.

Thank you!!!!


-Dev1
Feb 15 '08 #23
Dev1
38
No problem. I did redo it by the way to have you add a record because I noticed the problem with that when I was checking it for you. But I took out that code so you could try it on your own. (lol)

Ok, fare enough one question then. Can I code the save functionality without creating a new button object? Meaning put the code on/in the form itself?

Thanks!

-Dev1
Feb 15 '08 #24
Dev1
38
Ok, fare enough one question then. Can I code the save functionality without creating a new button object? Meaning put the code on/in the form itself?

Thanks!

-Dev1

Question, what is:

Private Sub Combo94_Click()
Me.Combo81.Requery
End Sub ?

Which combo box is that?

Thank you

-Dev1
Feb 15 '08 #25
Dev1
38
Question, what is:

Private Sub Combo94_Click()
Me.Combo81.Requery
End Sub ?

Which combo box is that?

Thank you

-Dev1
What ever you did is causing the filtering not to work!!

-Dev1
Feb 15 '08 #26
mshmyob
904 Expert 512MB
That was just a test I did. You can delete it if you want.
Question, what is:

Private Sub Combo94_Click()
Me.Combo81.Requery
End Sub ?

Which combo box is that?

Thank you

-Dev1
Feb 15 '08 #27
mshmyob
904 Expert 512MB
I will try to rewrite a bit of the code to help you out.

The problem is that with the underling table structure being so wrong what you are trying to do is like forcing a round peg in a square hole. It would probably be so much quicker to just start from scratch and do it correctly.

But I will try to work with what you have. Stay tuned.

What ever you did is causing the filtering not to work!!

-Dev1
Feb 15 '08 #28
Dev1
38
I will try to rewrite a bit of the code to help you out.

The problem is that with the underling table structure being so wrong what you are trying to do is like forcing a round peg in a square hole. It would probably be so much quicker to just start from scratch and do it correctly.

But I will try to work with what you have. Stay tuned.

Thank you, that makes since. I'm going to attempt a new data schema and post it by early tomorrow morning. Again I do appreciate your help. Just a curious quesion. If done right how long something like this would normaly take from start to finish?

-Dev1
Feb 15 '08 #29
mshmyob
904 Expert 512MB
For your scenario - It might take at most 1/2 hour to do the schema.

The forms for data entry maybe an 1 or 2 hours just to make them nice.


Throw in a couple of reports and a menu you could do everything in a few hours at most.


Thank you, that makes since. I'm going to attempt a new data schema and post it by early tomorrow morning. Again I do appreciate your help. Just a curious quesion. If done right how long something like this would normaly take from start to finish?

-Dev1
Feb 15 '08 #30
Dev1
38
For your scenario - It might take at most 1/2 hour to do the schema.

The forms for data entry maybe an 1 or 2 hours just to make them nice.


Throw in a couple of reports and a menu you could do everything in a few hours at most.

One other question. Can I have a sql server backend and a Access Forms front end (UI)?

-Dev1
Feb 16 '08 #31
mshmyob
904 Expert 512MB
Yes.....................................

One other question. Can I have a sql server backend and a Access Forms front end (UI)?

-Dev1
Feb 16 '08 #32
Dev1
38
Yes.....................................
One other question. If you have a relation data schema, how do you facilitate a import of data from one excel spread sheet to populate multiple tables?

Thanks you in advance,

-Dev1
Feb 18 '08 #33
mshmyob
904 Expert 512MB
Create a new thread for this question.

One other question. If you have a relation data schema, how do you facilitate a import of data from one excel spread sheet to populate multiple tables?

Thanks you in advance,

-Dev1
Feb 20 '08 #34

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: David Elliott | last post by:
I can create this: ?xml version="1.0" standalone="yes" ?> <ConfigOpt> <record> <Field_1>Text # 1</Field_1> <Field_2>Text # 2</Field_2> </record> </ConfigOpt>
4
by: amywolfie | last post by:
I've been trying to do something for about 3 days – I get close, but not 100%. I am trying to: Open frmRevisionHistory from a button on frmFeeInput. If there is NO RELATED RECORD, then I...
5
by: Apple | last post by:
May anyone can teach me how to assign a autonumber, I want to create a number that is starting with year(auto change to year 2006) + autonumber (eg. 2005-0001, 2005-0002)
0
by: Patrick | last post by:
I'm working on a contact management application, and need a hand with one aspect... Here's what I want to create: ------------------------------------ A form split into two parts. There is a...
0
by: Qajussi | last post by:
Hi! I am trying to create data entry forms like MS access forms using asp.net. I am talking about a form like MS access forms which let you enter a new record, edit, navigate to previous and next...
3
by: MarcJoseph | last post by:
I have a database that is shared my multiple users who enter and update records on a weekly basis. Is there a way I can add a field to my main data table that will automatically generate the...
4
by: etuncer | last post by:
Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is...
7
by: FNA access | last post by:
I have a mainform that has a subform in the detail section and a subform in the footer section.(Both subforms are in datasheet view) When I click the navigation button to create a new record on the...
12
by: tekctrl | last post by:
Environment; Win2K PC with 1Gb of RAM and plenty of HD space running Access 2002 Issue; Access presents a blank data entry form in the Forms view when the New Record icon is used. However, it...
1
by: cvillav | last post by:
Hello, I am new to Access and this forums, I have two tables and two forms to display the data. Tables Tbuilding Tcriteria Forms fmbuilding
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.