I'm using Access 2010 and cannot find where I can set my fields in a table to allow for allowzerolength.
Is there still a location, under table properties etc, where this can be set?
I want ot design a monthly table which shows each day 1-31 but I want to be able to enter a data value manually for each day.
I'm looking at building a query from the table which asks me for the date ie; 2Aug06 and then asks me for a value ie; 6 so the query (from which I can build my report) shows 02Aug 06 6
Regards
Richard
All,
I am using an Make-Table query to add many new fields to a Table using Fieldname: "".
However, when I use this, it sets the Allow Zero Length to No.
Is there code that I can use to stop this happening?
I am using this method for multiple fields and across multiple tables.
Your help appreciated,
Jem
I would likw for my first and last name fields width to match the length of the name. So if the last name is Smith then the field width will resize itself to fit perfect fit the name. Then if I have a last name of Connor then it will grow to fit it perfect. I dont need this but it will be nice so everything looks a bit nicer an cleaner. I thought the following would have worked:
Code : Me.Lastname.width = Len(Me.Lastname]
I have a table that stores ID,PolicyNumber,NewPolNo fields.It has millions of records. The field NewPolNo is empty. I need vba code that will check the following for each record:
1. If the length of the PolicyNumber is over 14 characters long then store that PolicyNumber value in NewPolNo field.
2. If the length of the PolicyNumber is less than 14 characters long thenagain store that PolicyNumber value in NewPolNo field.
3. But if the length of the policyNumber equals to 14 digits long then check the following:
a) If the last 7 digits are 0's of that PolicyNumber. If yes then store first 7 digits in NewPolNo field.
b) If the last 7 digits are not 0's then store the whole PolicyNumber value in NewPolNo field.
We need to check these conditions for each record of the table.
I have a table period with three columns
ID, Period_Start_Year, Period_End_Year
I could have many periods in a future. What i want is to allow users to insert just first start year and lenght of period and table will be automatically updated based on these two values.
So user will insert Period_Start_Year and Length of Period, for example 2010 and 2 and table should be>
ID Period_Start_Year Period_End_Year
1 2010 2011
2 2012 2013
3 2014 2015
While i am writing this i realised that user have to specify also ending year, i do not want to have infinity.. I am thinking about form and update query but can't get it...
I think this may be impossible but I am hoping it isn't :)
Have any of come across a way to Manually order a continuous form.
The way I would see it working is to have a column in the table called sort_order and two buttons on the form called move up and move down. Once clicked the sort_order value would change thus changing the order on the form.
I should imagine it would be alot more complicated than my brief description, in fact it may like I said be impossible.
If any of you have an idea how to achieve this I will be very grateful
Cheers
Paul
My table depends on the primary key ID to generate an entry.
I had 1399 entries done upto last night.
Somebody entered 1400th and deleted it . and next they continued from record #1401 to 1410. Now 1400 # is missing.
How I can manually enter 1400th record in my table.
Can anyone tell me what code I can use to manually enter data from a textbox. I don't want a bound box, but want to write some code that will take the text from that text box and enter it into a field in a table when i wish it to.
How is this code written please?
Thanks
Can't seem to figure this out.
I built a db for tracking and entering sales info but I'm having a problem with one of my combo boxes. To make entering data easier, I created a combo box that you can select a sales persons name from, then based on who is selected, their Title and Office location also populated.
The problem I have is when I want to manually type in the Name and other info for a temporary sales person. How can I allow users to choose from the drop down or just type it in if that person is not in the list?
Thanks in advance for your assistance.
why Access requires primary keys to be automatically generated so that there are no redundancies.We have a specific agreement with another organization that involves different billing system in which they send us purchase orders, each with a unique invoice number, that includes orders for one or more events.In my events table I have included a field to manually enter the PO number for this organization when it's needed.
I would like to have another table for the PO's with a one-to-many relationship with the events table (since each PO may cover multiple events). Is it possible to use this manually entered PO number field as a primary key to establish the relationship?
Is there a way to have an update query update values in a table based on the user's input?For example, I have categories of tests and educational assignments indigenous to a course I manage."How many students failed the Science Exam?" The user would then put the manual calculation in since it varies from semester to semester.
View 6 Replies View RelatedI have a simple table with two fields in that table called:
1. BankName
2. BankNumber
Each bank has a bank number. For example Bank XYZ and all of its branches have the same Bank Number 123. There are 5 banks I have listed in a combo list under the BankName field. I can also type in a different bank in that same field if it is not listed in the combobox list.
Now, I want the BankNumber to automatically populate based on what I choose under BankName. If the BankName is manually entered (for banks that are not in the combobox), or if the BankName field is blank, I want the BankNumber field to be able to enter a number manually.
For example, if I go to the BankName field and under the combobox I select Bank XYZ, i want the BankNumber field to automatically populate as 123. If the BankName has a bank name that was manually entered, i want BankNumber field to allow me to manually enter a number.
Thanks for ur help. I couldn't figure this simple request out.
Greetings everubody,
I've a problem and hope to get answers for,
The situation is that I have a table named patient and a form named [patient1] where it holds a textboxs named "MFC_Seq_no" and another to hold [date], now, I manged to do a manual auto numbering for "MFC_Seq_no" using the following VB :
Private Sub Form_Current()
If Me.NewRecord Then
On Error Resume Next
Me!MFC_Seq_no.DefaultValue = Nz(DMax("[MFC_Seq_no]", "Patient"), 0) + 1
End If
Whenever user create new record, the system will automatically store the next number in the new record.
Now, I've be requested to code that system to start again from 1 as value for "MFC_Seq_no" whenever there are changes in date field (i.e. next day in the date field)
Is this doable and how?
Q2. how to duplicate an entire record with a subform, from another table, in it?
Thanks,
I have set up a form on which there is a graph which draws data from a query. I have set up a text boxes to take in the Y axis min, max and interval values so the user can customize the graph according tot he range coming out of the query. This all works fine and is perfect, however, i also need a report and set up a report with the same graph which can be printed to pdf, however, i cant get the y-axis to adjust like i do with the one on the form,
View 11 Replies View RelatedI have a form that when a user fills out the information and select a submit button. It brings up that record in reports in print preview for them to print. The issue i am having when the user enter the information, the report does not show any data until i refresh it. I tried include me.refresh,etc. No luck. I attached the code to make things simpler.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Dirty Then
If MsgBox("Do you want to Submit this Contract Form? Clicking No will DELETE ALL ENTERIES,and Log You Off", vbYesNo, "CONTRACT FORM") = vbNo Then
Me.Undo
Cancel = True
Else
If MsgBox("PRINT FORM", vbOKOnly, "CONTRACT PRINT") = vbOK Then
DoCmd.OpenReport "rpt_Contracts_Main", acViewReport, , "[CONTRACT_ID]=" & Me!CONTRACT_ID
End If
End If
End If
End Sub
The reports comes up, but i have to manually refresh it to show the data that was enter.
Installed Access 2003 recently and could swear that on a form in design view, sizing a control button for example, by holding down shift key, worked as I expected; it sized up or down by 1/4th of a grid line.
Today, I hold down shift and size a control, and it sizes up or down by one full grid line. Can't find anything in Options that I might have changed, nor in the Format menu.
Does anyone know what may have caused this?
I am new to the Access database building. I am trying to create a Student database for contact information, etc. I have a main table which stores all the users' data. When the student opens the database, I would like to identify the user. They should be able to view everyone's information, but only edit their own. How can i make this happen?
Also, if that is easy enough, I would like to identify when a staff member logs on. This way they can have special permissions to access a schedule searching feature, to look at all the students schedules.
Thanks for the help.
Mike
Good Morning,
Im trying to set an ODBC connection to automate the connection process.
The current code I have is:
Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
MsgBox "Opening Connection...."
Set MainConn = wrkODBC.OpenConnection("Connection1", dbDriverPrompt, True, "ODBC;DATABASE=live; DSN=live;")
which works fine in bringing up a dialog box to choose the connection.
But what do i write in the database and dsn fields to enable the automation process.
See attached picture for the log in settings. All I have to do is press 'Connect' to start talking to the ODBC.
any help would be greatly appreciated.
Justin
How to swith sleep mode off? Does anyone know? thanks
.................................................. ............
<offending URL removed>
I have been looking all over for this function in MS Access 2007. Anyone have an knowlege on how to access the Startup section?
Thanks a bunch, :D
~Kilch~
I'm new to my job and ms access and not very savvy in the latter. There are fixes for my problem on the internet, but I really don't understand them.
I'm used to dd-mm-yyyy format and it's tough for me to think in mm-dd-yyyy in, for example, MS outlook. If I change my regional settings, of course, outlook and access follow suit. The access database is shared and we print out records as cover sheets for our files. Thus, it's not an option to have me on dd-mm and others on mm-dd. Is there a way for me to enter mm-dd in when using the database but have dd-mm standard for every other aspect?
If you can help, which I would appreciate immensely, please pretend that I don't know what I'm doing.
Thanks
I designed a query, opened it and printed it. But the margins were too wide and I needed it to print in landscape also. So I changed the settings and it worked fine, but I can't get it to save the settings. Is it possible to save the printer settings for printing a query, both the margin and the landscape settings. If so, please tell me how. Thanks.
View 4 Replies View RelatedHI
If i set the print settings (page orientation, size etc) when i have a query open, Access has forgotten it next time i open the query.
How the smeg do i get it to remember the print settings?
Please help me im running out of hair!
Thanks
Hi.
I have had a server change and db was moved and I need to change the IP etc. Is there a easy way to do this? I have searched through this forum in vain. :(
Kind Regards
Marie
Is there any way to change the default settings on the Find and Replace dialog from 'Whole field' to 'Any part of field'?
Thanks very much in advance.
Rob
PS Happy Christmas!!