Forms :: Creating Number Of New Forms To Edit Number Of Tables

Oct 29, 2013

I am using a template database that I downloaded from the Microsoft Access template website and have been modifying it and adding new forms and tables etc. I have used the forms wizard to create a number of new forms to edit a number of the tables. The forms are "split forms".I can't seem to get many of the forms to stay the size that I set them to! They seem to have a mind of their own and often when I think that I have sized them correctly, I then open the form and they display in full screen mode or larger!

View Replies


ADVERTISEMENT

Forms :: Creating Lookup - Populate Contact Number Based On Selection From Combo Box

Mar 31, 2015

I want to create a text box within a form that automatically populates a contact number based on a selection from a combo box, also in the same form.

For example, I have a Bidders Table (tblTenders), this form includes information regarding the Tendor like the company name and a main contact within that company and a phone number for that contact.

I've created a separate table for all the contacts called tblContacts. This table holds all the contact information for each contact. I have a simple form called frmTenders that asks the user to input the Customer (which is the company who are bidding) and the Main Contact, which is a combo box to select the main contact from tblContacts. Below that combo box is a text box called 'Contact Number' - I want this box to display the contact number for the main contact automatically when a main contact is selected from the combo box.

The contact number text box isn't storing that information in any tables etc. It's just for viewing purposes when we need to make a call to that specific tender.

View 5 Replies View Related

Forms :: Auto Generate File Number Based On Number Of Records In Year

Jan 21, 2014

I have a form [IUDATA]

I have a add record button.

I have a date field [DATEIN]

I have a text field [DRPNO]

If the [DPRNO] field is empty, I would like the user to have the [DPRNO] field be automatically populated after the user enters a date.

I'd like the format of [DPRNO] to be "dpr YY-XXX"

Where:
YY is the year of the [DATEIN] field and
XXX is number of records in that year.

So for example, if it was the 4th record with a 2013 date the [DPRNO] would be dpr 13-004.

View 12 Replies View Related

Forms :: Generate Random Number To Use As Invoice Number

Mar 17, 2014

I am working on a form and need it to be able to generate a random number to use as an invoice number. The only parameters i need it to meet is that it is at least 5 digits in length. I was hoping i could use a button to make the number generate in a separate box.

View 5 Replies View Related

Creating A Serial Number That Is NOT Auto-number

Mar 20, 2012

I have a table called "OrderDetails" with following fields:

Num
OrderID (Primary key)
Product
Quantity
Price

I want to create a data entry subform that can used to enter order details in this table such that, for a given OrderID, the Num field is automatically set to previous number + 1. For example, for OrderID = 12, if there are 4 products that need to be entered, the 4 records should automatically take 1 , 2, 3, 4.

View 6 Replies View Related

Tables :: Creating A Unique Invoicing Number?

Aug 19, 2013

What I have is a small POS system I'm trying to create a unique invoice number for each transaction (multiple records)

I have two tables, one named "CurrentTransactions" and one named "Past Transactions".

I have everything working except the invoice number my system works by adding pre defined records into the table "CurrentTransactions" and once the sale has been finalised it transfers the data to the "PastTransactions" table.

take the last number from the "PastTransactions"."InvoiceNumber" to create an invoice number in the "CurrentTransactions", and I want to be able to do it using an expression in the default value property as opposed to in the form ( I've tried the form way but using Dmax would require me to almost rebuild my entire POS system )

View 5 Replies View Related

Forms :: Create A Form That Incorporates Number Of Different Tables And Tabs

Mar 7, 2013

I want to create a form that incorporates a number of different tables & tabs. When I switch tabs (which represent the information on the different tables) I need it to be consistent with the main table and all the information that follows it from the different tables.I've been told the best way to do that is with a parent form but I haven't been able to find an EASY step-by-step instruction on how to do that.

View 2 Replies View Related

Tables :: Consecutively Number Table Rows With User Determined Start Number

Jul 13, 2014

I have an Access2007/SQL Server 2012 system with 20 users for an insurance company. The company does most of its business via a network of vehicle dealers around the country. If someone comes in to buy a motorcycle, boat, or recreational vehicle at a dealership they need insurance to take it home, and our dealers send the quotes to us.

The dealers, in turn, receive payment from us each month for their efforts. Some are paid a % commission on the premium, some are paid for each quote they send regardless of whether the policy actually sells or not, and some are paid a set amount per sold policy. (Yes, that is relevant information!)

We already have reports that tally the amounts due each dealer based on their payment scheme, but last month our bookkeeper had to write about 650 checks manually because the check writing is not automated. She'd look at the report, and then enter name, address, and amount (in digits and words) into Quick Books and print the checks from there, a horribly tedious process. I've been asked to print the checks from Access. Basically one click would print all 650 checks.

I've opted to use a Make Table query to move the commissioned dealers amounts to a single location, and then to run two append queries to add the records from those paid per quote and those paid per policy. At the end of the day, one table contains all the information necessary to print the checks...except one.

The check number.

I need a way to sequentially number each record in the new table with a user generated starting point, the first check number.

By the way, the check blanks are on standard letter sized paper, three to a page, with tear-off perforations to separate them, in case that information has any relevance.

I think the best way to accomplish this is from the report itself. I've created a blank field on each record for the check number, and what seems most logical is that the sequential number is generated on print and written back to the table, rather than just generating all the numbers at once. That way, should print ever be interrupted, it will be easy to take up where we left off.

View 14 Replies View Related

Tables :: Procedure To Restrict / Stop Auto Number Increment For Certain Number Of Record Count

Mar 16, 2014

I would like to know if there is any procedure to restrict/stop auto number increment for certain number of record count (say 50), then increment by 1 for next 50 records.

View 8 Replies View Related

Forms :: Number Of Buttons Which Open Other Forms And Filter Results Using Embedded Macro

Apr 6, 2015

I have a bit of a problem with a database in Access 2013. On 1 of the forms, I have a number of buttons which open other forms and filter the results using an embedded macro. All has been well until a few days ago when error 2950 pop up box started appearing. After fiddling around for a while it all works OK (without actually changing anything) until next time the database is opened. I checked to make sure the location is "trusted" and all seems OK.

View 4 Replies View Related

Forms :: Use Form To Edit Records In 2 Separate Tables

Apr 2, 2013

I have the logical process, but I just don't know how to put it into code.

I have a form with two boxes HireMovieID and HireCustomerID, with a button HireButton.

The two tables which I have are CustomerInfo and MovieList.

Here's the psuedocode for what I need to happen:

Code:
IF HireMovieID.Genre = "R16"
(IF DOB > Today - 16 years)
Display Error: "Too young"
ELSE Hire()

[Code] ....

I need to somehow make it so that the MovieID is valid, as in, if it doesn't exist then it comes up with an Error MsgBox.

View 4 Replies View Related

Reports :: Edit Current Report That Lists Production In Week Number Order?

Feb 26, 2015

I've been asked to edit a current report that lists our production in week number order. I need to look at way we can 'flag up' orders that are within a 4 week period from the current date.

For example,

10 Orders in total in our database. 5 of which are due the drawings back within 4 weeks from today (26/02/15). I'm looking for a way for the report to show the 5 orders as priority, either by formatting the orders in bold, a different colour or under their own heading/group.

View 14 Replies View Related

Forms :: VBA - Whole Number Convert To Hh:mm

Aug 14, 2013

I have a textbox that I put in minutes as whole number. What i want is to put in AfterUpdate Event to convert that whole number to hh:mm....

View 4 Replies View Related

Forms :: Add A Number To A Field

May 6, 2013

I have a field PCVno on a table. This field should update on double click from a combo box (on double click) on a form.

View 1 Replies View Related

Creating A Random Number

Jul 8, 2006

Quick question, how do I have access generate a random number between 1 and 8? I want it to generate either a 1,2,3,4,5,6,7, or 8. (no zero, no nine)

Expr1: Fix(Rnd(8-1)*10*Rnd()) is what I have been using, but this always generates the number 2? I do want the decimals to be rounded to the nearest integer, thus I have Fix.

If someone could please help me, it would be greatly appreciated! Thanks in advance.

View 3 Replies View Related

Creating ID Number In Access

Mar 1, 2012

at the moment we have been given this problem where we have to incoporate a Dmax function into the following code

IDnumber = Left(Firstname, 3) + Left(Lastname, 2)

from this code the ID number creates something that looks like this

gembl

however i need a four digit number after this ID, for every different ID i need the numbers to increase by one the following code was given to us to do in Got Focus but this did not work

IDnumber = Left(Firstname, 3) + Left(Lastname, 2) + Trim(Str(DMax("right(IDnumber,4)","Customer tbl")+1))

View 3 Replies View Related

Forms Question - Account Number

Feb 3, 2006

I have a list of account numbers for members, they have distinct member numbers. I have it set up for users to search for the member, then the member number will auto-populate. I also need to account for members with no member number. I would like to have the user click on the check box "Non-Member" and somehow assign a Member number...starting with NM. So the first non-member would be NM00001, next NM00002. I thought I could create a table with the sequence of NM numbers. I am just unsure of how to tell my form to populate that field when the Nonmember box is checked.

Any ideas?

View 1 Replies View Related

Forms :: How To Limit The Number Of Records

Jul 4, 2013

I want to limit the # of records being entered in a form according to a limit value which has to come from a query.

View 11 Replies View Related

Forms :: Text Field To Number

Jun 4, 2013

I'm scanning serial numbers in a field, but the results always start with an S...like S123456789 , S107432567 etc.. how can I eliminate the S and make this field numeric?Access 2007 being used.

View 4 Replies View Related

Forms :: Displaying Record Number?

Jun 5, 2014

how to make a text box on a form display the record number so it can be seen along side record selector buttons.

I'd rather have my own then use the record selector option that displays at the bottom of the form when enabled.

View 4 Replies View Related

Forms :: Turning The Month Into A Number Using Vba?

May 7, 2013

im doing my ict unit 7 edexcel ict exam atm and as one of the tasks we have been asked to generate the testid. the test id consits the year a underscore and then the number of the month so for example if a test happened this year and this month the test id should be 2013_5. i can get the year and the underscore into the code to generate the testid but im not sure how to get the month to change to a number so for example if i select may from a drop down the code needs to take that and generate it into a number.

View 6 Replies View Related

Forms :: Number Of Days Calculation

Dec 9, 2013

i have a form where I enter two dates i.e. a commence day and a final day and I also have a save button.I would either

a. have a control on the save button which pops up a message if the final day is greater than the commence day and so preventing the save record

b. Or if the final day is entered and is recognised as a date before the commence day then to pop a message saying so and preventing the save record.

View 6 Replies View Related

Forms :: Sort On Number Adding 0

Jul 3, 2015

Access 2013.

Table field is set to: Number/Byte, 0 decimals.

The field is used to sort records in a particular order.

In the form it is set to Standard, no Decimals and no Default Value.

When I create a new record and type in: 1, it makes it 10, 2 becomes 20 etc.

If I delete the value and type it in again, it does not add the 0.

It only does it in the form, not when I enter it in the table directly.

View 1 Replies View Related

Forms :: Multiply A Text Box Value By A Number

Sep 10, 2013

I have a text box in a form that is producing a number from the query that the form is based on.In another Text Box i want to show the Value of the first Text Box multiplied by 3 because i am going to hide the first text box to only show the calculated number.

At the moment i have this in the control source of the text box [CountOfJobID]*3 but all i am getting is #####...I have set the format of the text box to General Number.

View 5 Replies View Related

Forms :: Number Separator In Subform

May 15, 2013

I needed to change the decimal symbol from a dot to comma for use in Europe. On changing the the settings to a comma everything works fine but for the field that I have the code in the AfterUpdate properties

Private Sub SprayCfuelC_AfterUpdate()
Me.Dirty = False
CurrentDb.Execute ("UPDATE ProcessData SET ProcessData.SprayCFuelC =" & Me.SprayCfuelC & " WHERE (((ProcessData.AuditNo)=" & Parent.[AuditNo] & "));")
Me.Recalc
End Sub

Now when the data is changed I get a run time error 3144 - syntax error in UPDATE statement.

View 5 Replies View Related

Forms :: Number Format With Space

Jul 15, 2013

In my table i have a field ID here are values like as 123456 234345 233434

I wanna make report with this table, here ID field will be shown up with space every number

Example : file value : 12345

I want in report : 1 2 3 4 5 6

View 4 Replies View Related







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