Computer Support Forum

Access form not displaying all data

Question: Access form not displaying all data

Hi,

I am trying to create a data entry form for a large database. There is a parent form with 6 forms linked with a one-to-one relationship (due to a large number of fields) and several tables linked with a one-to-many. All have auto update/delete checked. The date entry form uses tab control (across 11 tabs) and subforms for some of the tables. I have two problems...

Firstly, if I enter part of the data for a new record in the form (eg fill in tabs 1-3) and then close it, the data appears in the tables, but when I re-open the form the record does not appear, so it is impossible to complete the data entry.

Secondly, when using the tab key to move through the fields in the table, when I get to the end of a tab control, instead of moving to the next tab control for the same record, it moves to a new record on the same tab.

I am fairly new to access and not familiar with all the code etc behind it, so I would be grateful for any advice!

Thanks

Relevance 100%
Preferred Solution: Access form not displaying all data

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Access form not displaying all data

9 more replies
Relevance 95.12%

Hello OBP and others,

I have 3 Access XP survey forms that are not displaying the uploaded data in the tables, though they are restricting the number of records to the number of surveys in entered into the tables (as they should be doing). The "Data Entry" settings are set to NO for all forms and subforms. Do you have any suggestions as to how this can be fixed?

Thank you,
TMet
 

Answer:Access XP Form Not displaying Table data

16 more replies
Relevance 91.43%

Hello!

I have linked my calendar 11.0 to my text boxes, and then to my query criteria. Everything works, except after I click on the Calendar to choose my end date and it shows up on the text box thats linked to the query, the information from the query doesn't automatically show up on my Form in other text box I have linked for results (d*count funtion, etc).

BUT, when I go into design view, and then back to form view, the Data is Updated!

So I am very confused as to how to set it up after I input the end date to automatically update instead of hitting the design view and back to form view for it to update.

Not sure if a "refresh" or "after update" function needs to be in place? I hope I explained it correctly! Thank you!
Jess
 

More replies
Relevance 77.08%

Hi folks, I have a multipage form as part of an Excel development that requires checking the completion of fields on page 1 when a user enters page 2. All very straightforward I thought having done it many times before in word macros

eg If Multipage1(0).<variablename> = "" then
msgbox(<error message>)
multipage1.value = 0
<variablename>.setfocus
Else
End if

but no. The tab of page one is activated but the form controls displayed remain stubbornly those of page 2 and vb sicks up because it can't see <variablename>. The only reference I've found to this is that it was driving people mad and 'appeared to be a bug in XL2003'(sic) I'm using Office 2010.

Has anyone else had this problem, and more importantly found a cause/solution?

cheers
 

More replies
Relevance 75.03%

I basically have a Main Menu form, on which I have a variety of tabs. On one of the tabs I want to have a series of combo boxes from which users can enter/select the value they require. In the After Update I need some sort of code as below, that will allow me to display the record/s matching the value provided/selected by the user.

docmd.OpenForm(frmImprovements,acNormal,,[[Forms]![fmnuMainMenu]![cboID].[AfterUpdate]=[tblImprovements]![lngID]],,acWindowNormal)
-this command is expecting an =

So a user has a combo box called ID, they may enter or select a value from a drop down list, a form is then displayed from tblImprovements in frmImprovements. What am I missing? Any ideas?
 

Answer:Filtering in Access and displaying in a form

I think you have the order of the filter wrong. Also you should not need the .AfterUpdate piece of the combo box. Try
docmd.OpenForm(frmImprovements,acNormal,,[lngID]=[[Forms]![fmnuMainMenu]![cboID]],,acWindowNormal)
 

1 more replies
Relevance 74.21%

Hi all,

I am a beginner to MS Access. I was trying to create a form in Access which has 3 combo boxes on it, with each of them having the data on accountname, report type and date respectively. This data comes from 3 tables which are two column tables with one filed being the primary key one and the other fiield having the say accountname as type Text and so on. The form has the functionality that as a user chooses a particular combination of accountname, report type and date from the 3 combo boxes and clicks on a button titled 'Display report' the respective pdf file opens up. These pdf files are stored in a particular folder and are named as a concatenation of 'accountname+reporttype+date'. The form also needs to have a button clicking on which the user can close the form.
Any directions members !

Also could anyone explain me what actually a query is and what relationship does it have with a form. I have some idea about this but i am still not fully clear about these concepts.

Chow
Goels
 

Answer:Creating a form in MS Access for displaying reports

i posted a similar question about 2-3 weeks ago... I hope someone has the answer...
 

2 more replies
Relevance 74.21%

Hi Guys
First timer - so please tread gently! I'm sure this is a similar situation, but wasn't sure whether it warranted another separate conversation.
I have a situation on an unbound list box in Access 2000 and haven't yet got to the bottom of it. I have a box which displays incorrect records for the user to correct. When they first go into the box, they see all 500 records (for example) and use a dble click event to edit the one they want, when they return to the box it will only display the first visible amount of records. They can use the scroll bar but the records do not scroll!

The Code behind ( and here's where I get lost - I don't do VB!) opens another form, allows you to edit the record, saves the changes, closes the form and returns you to the original form. We have tried keeping the original form open, as it was closed and reopened, but no change.

The DB has been inherited, so I have no idea why a List box has been used an not a combo.
Forms data is taken from a query.

I'll work out how to post a copy of the empty DB to you!
Jacally
 

Answer:Access 2000 - Not displaying all records on Form

6 more replies
Relevance 73.39%

I'm sure this is an easy fix but I can't seem to find it. I just have a form, that will be a subform of another, that needs to display the results of a query.
The query is simple enough, just displays all fields of records that fall between specified dates. The query works great, but when I attach it to the form as its record source it doesn't display the data. I can see the correct amount of record selectors so I know its understanding the query but its as if all fields are hidden!

I have also tried building a query to the forms record source that was simply Select query.* From query. Oddly I have had this working before but I had to specify every field. What I mean is:

Select title From query
Select type From query
Select date From query ...

And so on for all the fields but this seems foolish, can anyone think of what I may be doing wrong?
Thanks in advance!
Edit, forgot to mention I also tried the foolish solution that I mentioned above and it didn't work so its definitely some issue that I'm not seeing, some property that's probably not appropriately set
 

Answer:Solved: Access 2010 form not displaying query

8 more replies
Relevance 71.75%

Hello - I am currently building an "Agent Journal" Database. This will be an area where supervisors can enter "Journal Entries" for their direct reports. The way it is currently setup is: The Supervisor form pops up. Supervisor selects their name from a dropdown, and select a command button. This opens another form with another dropdown that lists only the selected supervisors direct reports. Once the "direct report" name is selected, they will hit another command button that opens the "Journal Entry Form" On this form, there are text boxes for Supervisor and Agent. These fields are auto-populated based on the names selected on the previous 2 forms. There is also a combo box where they can select a "reason" from a dropdown menu, and a date picker so they can enter the date. The problem that i am having is: The data entered into the final form will not save to a table. I want to maintain the auto-populating of the Supervisor and Agent names when this form opens, and i want to have them select a command button to save all of the data on this form to a table. Can anyone help me with this????
 

More replies
Relevance 67.65%

I have a combobox in a subform within a subform that will not display data when the main form is displayed/loaded. If I click on the combobox (giving focus to the field) the data will appear. All other data within the subform displays fine.
 

Answer:Access 2003 ComboBox not displaying data

13 more replies
Relevance 67.65%

I’m creating a website that will handle tons of data, using MS SQL Server for the active content, basically dropping records into a variety of webpage templates for the end-user. But, my back-office first has to sort through tons of raw data and whip it into shape, drafting and editing text, cropping/resizing photos, assigning links, etc. I’m using Access 2003 for that process, to handle everything that is not yet ready to be imported into the SQL Server for publication to the live website.

I understand that I can display data from an Access db on a webpage, somehow (just a facsimile of the real webpages in which it will be displayed, later, one record at a time). It would be very helpful for the back-office staff to have an in-house, interactive way to see how the data they’re editing will eventually appear on the website, giving them insights into how they need to adjust it further.

My head is reeling from all of the different stuff I’ve read about how I might do this. Can you all give some general advice on how I should get started, which direction I should take?

Thank you.
 

Answer:Displaying Access data records on a webpage

Access 2000-2003 uses Data access Pages to display data on the Web. They are an html version of a Form and can be created by saving a Form as an access Page.
See
http://support.microsoft.com/kb/264080
 

1 more replies
Relevance 66.01%

I am using Microsoft Access 97. I have set up a database with many fields. I have created a form for data entry.
I want to print a form with the fields and names of fields on paper so that it can be used by people to fill in the information and then someone else can enter the data.

I cant seem to get this done automatically like the form was set up with the wizard. I cant print the blank form from the wizard.
Please help.
Thanks
 

Answer:Access: How to print a data entry form

6 more replies
Relevance 66.01%

Hi. This is my first time ever using MS Access, and I'm a little stuck on something. I'm creating a database in MS Access 97 which keeps track of rail car incidents. The main menu of my database is a form consisting of combo boxes and a command button. The command button takes you to a data entry form bound to a table called tbl_incidents. This form allows the user to add or edit data in the Incidents table.

I also want the user to be able to search the incidents based on user-specified criteria. This is where the combo boxes come to use. I have 2 combo boxes, one each for a specific field in the Incidents table: Date and System. Instead of binding the combo boxes to their respective fields in tbl_incidents however, I created seperate tables called tbl_date and tbl_system for the combo boxes. These tables are indexed with no duplicates, this way each value is only displayed ONCE in the combo box. I cannot index the fields in tbl_incidents with no duplicates because tbl_incidents is used as a log for all problems relating to the rail cars and each incident needs to be recorded with its corresponding date and system. So for instance, I may have one entry:

[Date] 6/2/11; [System] Brake; [Incident] Brake fault on car 1555

Then I may have a following entry with duplicate dates and systems, but with a different incident:

[Date] 6/2/11; [System] Brake; [Incident] Brake pipe on car 1234 frozen

So, I need to allow duplicates in tbl_incidents. For this reason, I c... Read more

Answer:I need help with a data entry form in Microsoft Access 97

Your main issue is to bring Unique values of Date field (don't use the field name as Date because it is a builtin function, use something like incDate for incidents date) and System Fields of tbl_incidents into the Combobox Source. For that you don't have to maintain two different tables, one for date and the other for system.

You can create two Select Queries from the tbl_incidents itself and use them as Row Source for the combo boxes. This way you don't have to worry about adding the same record information on three different tables at the same time.

Copy the following SQL into a new Query's SQL Editing window and save it with the name incDateQ:


Code:

SELECT tbl_incidents.incDate
FROM tbl_incidents
GROUP BY tbl_incidents.incDate;

Create another Query with the following SQL for System combobox source, name the Query as SystemQ:


Code:

SELECT tbl_incidents.system
FROM tbl_incidents
GROUP BY tbl_incidents.system;

Use above Queries as Row source for Date as well as System Combo Boxes replacing the Date and System tables you are using now.

This way you don't have to bother about updating all the three tables at the same time. When you add a new record with different values they will automatically appear in both Combo Boxes.

NB: The current new record values, if different, may not immediately appear in the Combo Boxes, but it will update when you move out to another record.
 

5 more replies
Relevance 66.01%

Hello to everyone on my first posting ever,

I am a novice and a very green user of Microsoft Access but I have taken on the daunting task of trying to set up a database for our local high school lacrosse team. As part of that, I am designing a Data Entry Form to caapture and record the stats for a game and have set up a field with a combo box which requires the user to select the type of stat. If the stat type is a penalty, I would like the form to automatically enable three other fields that I have disabled in order to control entries to those fields. The first disabled field is a combo box with a penalty description drop down list; the second is the duration time of the penalty which is a one decimal number field and the last is a yes/no check box asking if the penalty is a releasable penalty. How do I "activiate" these fields for entry only if the type of stat selected is "PEN" for penalty?

I apolgize in advance for the length of the post, but it must be the preacher in me. Can someone help an old preacher who is too cheap to buy software already on the market which will do the trick and thinks he is smart enough to do it himself?
 

More replies
Relevance 66.01%

So, subsequent to my previous thread...

(Basically, I have an Access database which is to be used by many users to make changes).

...once the record has been amended, I need to allow the user to either "save changes" or "exit without saving". At the moment, the data is updated as soon as I leave the form - how do I get round this?

Thanks

Ed
 

Answer:Solved: Saving (or not) changes to data in a form in Access 97

If the user does not want to save the changes (or additions) they can press the Esc twice to "Undo" the Actions.
However if you want to have a second Button that says Close without saving then before the button's VBA code Docmd.close enter
Me.Undo
 

3 more replies
Relevance 66.01%

I have a form called GET ORDERS that requires input( i.e. Customer #, product, qty...etc) The form has a field called TOTAL PRICE. In the properties for TOTAL PRICE, on the DATA tab, I have the following calculation in the control source field
=[SalesTax]+([UnitPrice]*[Quantity])
Now that expression works fine and displays the correct total price. However, I'm looking for a way to commit that value to my ORDERS table, in the TOTAL_PRICE field.
I'm assuming that I can do this under PROPERTIES and the Event tab..... I'm looking for someone with a little more Access experience to provide some help. Thanks in advance for your time.....
 

Answer:MS Access: Enter data into a table from a form.....

Hey. Will this help?
http://support.microsoft.com/?kbid=292042

That'd be cool, 'cause I found it pretty quickly.

 

3 more replies
Relevance 66.01%

Hello

I am using Access to hold data. The table in Access runs across from right to left. I want to copy the data that runs from right to left and paste it into Excel from top to bottom ( up and down). Is there a way to do that without doing one field at a time. When I copy out of Access now and try to paste into EXCEL it of course paste's it across not up and down like I need it to

Thanks
 

Answer:Data from Access table to Excel Form

Once it's in XL, you could try re-copy ; then (in a free area), Edit -- Paste Special -- Transpose -- OK.

HTH,
Andy
 

2 more replies
Relevance 66.01%

I have a database with multiple records which track training records of individuals. To update a record I open a form using a combo box linked to the table. One of the fields need to be checked against the current date and colour value adjusted as needed. I am using the following code to set the value:

CurrentZoneMonth = DateDiff("m", [ZoneStart], Now) + 1

When the value reaches 1, first month of training window, it flags until the training is completed. The problem is the value is not being set. It works fine when I place it in the FormLoad event, but using the combo box it is only initiated when the form loads. Because of the combo box search, it needs to be placed in the OnCurrent event instead and it keeps causing an error due to Update or Edit method not being invoked.
When the code is in the FormLoad event it will work when I go and manually re-input the ZoneStart value, it updates correctly and changes the field.
Any push in the right direction would be appreciated.
 

Answer:Form data loading problems (Access 07)

6 more replies
Relevance 66.01%

I created a MS Access form for data entry. As the user enters in the address information, I want to check the table to see if the name and address is a duplicate record. Does anybody know a way or have some code to help me out?
 

Answer:MS Access 2000 Data Entry Form

6 more replies
Relevance 66.01%

Hello,

We are currently running access 97, we have a database table created, but when we enter on the form that we have created the date and time does not show up on the table. We have on the form the date and time automatically set. Is there a way to have it transfer to the table??
 

Answer:Access 97: Transfer Data From Form to Table

Sounds like you don't have that form control linked to the table. I'm not sure how to do it off the top of my head, but you can try right-clicking the data field in form design view, and go to the Data tab and check out the control source. It's gotta be something like tablename->field. If you hit ctrl-F2, you should be able to "build" it. It may be helpful to you to look at how another control in the form is set up, then duplicate it, but change it to the date field.

(Maybe that'll give you something to do until the troops arrive.)
 

1 more replies
Relevance 66.01%

Sorry for all the posts but as I work through the design I think of new ways to make it better/easier which is the main requirement of it. So here's my question, I have a data entry form to at items (Movies/Games) into the inventory. The form comprises of ItemID, TitleID, Title, Producer, Category, Type, HireFee and Copy. I am unsure on TitleID at the moment, but where the title is entered once into the tblItemDetails table, it can be entered numerous times in the tblInventory table so I am considering this TitleID to reduce data usage. Now, is there a way to repeat the entry numerous times without having to re-enter data? As in, there's five copies of a movie, input five entries to tblInventory in one go, rather than having to re-enter all the information again and just have a new ItemID and Copy number for each.

That, or can I just have it so that I enter a new title, e.g. 'Fallout 3' along with all the details, then create a new entry and having title as a combo box being typing and select 'Fallout 3' and have all the other fields auto filled? Because all that will be different is the ItemID which is an autonumber and the copy number...

Sorry if that doesn't make any sense.

Thanks in advance,
Mark.
 

Answer:Access 2010 - Data Entry Form

Mark, the TitleID (like all repeated data) should only be entered once.
ie the data goes in a table for the Game/Film and then the titleID is used in the inventory along with a Quantity field ie 5 copies) which is updated when the item is issued or returned.
The issuing and returning should be logged in a separate table.
 

1 more replies
Relevance 66.01%

How am i able to modify data in a form that is loading data from a query? I only seem to be able to retrieve data, but not upload. More specificly I use a query to filter some data from my table. With a form, i then want to be able to update some of the values (in my table ànd query). I have to use the query since not all colums/rows from the table may be displayed.
Any help is welcome!
 

Answer:Access 2000: Data entry in a form

What application are you using?
 

2 more replies
Relevance 66.01%

Hi all,

I want to use the DoCmd.TransferSpreadsheet command to transfer multiple queries into separate tabs in one Excel workbook.
The issue I have is that many of the queries I want to export use Query by Form for the user to enter date selection. Is there anyway I can use one form for the user to enter the dates & these dates feed into the other forms that drive the separate queries?

As an example, there is a form called Form1 and Query1 has field [Forms]![Form1]![StartDate]
and there is a second form called Form2 and Query2 also has field [Forms]![Form2]![StartDate]

Is there anyway I can have ExportForm display and have the selected date [Forms]![ExportForm]![StartDate]automatically feed into both [Forms]![Form1]![StartDate] & [Forms]![Form2]![StartDate] in their seperate queries? Without opening the individual forms and queries?

How would I change this code to do this?

Code:
DoCmd.TransferSpreadsheet acExport, , "Query1", "c:\Test.xls", True
DoCmd.TransferSpreadsheet acExport, , "Query2", "c:\Test.xls", True
Thanks!
janie
 

Answer:MS Access DoCmd.TransferSpreadsheet with form data

If the Start date is the same for all the Forms, why not just have one form for all the Exports?
 

2 more replies
Relevance 65.6%

Hi,
I think I have always over complicated things by creating several copies of a form for each query it will display. Then when something changes I have loads of places to change it. Is there a way that I can have one form and determine which query is displayed in that form using the Filter Name option in a Macro?

So... someone clicks a button and it will open a form based on a specific query and ask for any information required by that query (input boxes) and then display the form with relevant information...

Thanks in advance for any help!
 

More replies
Relevance 65.6%

I apologise in advance but although I was once fairly proficient in Access, I have had a baby and not touched it for over 2 years and am now using 2010 instead of 2003 and feel like my Grandma would trying to send an email!

I have a really daft issue...

I have a basic database, Client table, Treatments table and various lookup tables.

I have a form to view/enter Client table records (frmClientandTreatments) twith a subform showing related Treatments. I store a Condition (e.g. Arthritis) in the clients table which is looked up from another table that provides the category (e.g. Muscloskeletal)...I want to have the category display on the Client form when a Condition is selected. How do I do this as the record source of the form is the Client table? I tried setting up a query as the record source but themn the combo boxes didn't seem to work and it wouldn't let me add new records...I am confused!

Also, should I create relationships to lookup tables? Enforce referential integrity?
 

Answer:Solved: Access Form Display related data

16 more replies
Relevance 65.6%

How do I get the new record entery to show up at the top of a continuous form? It currently is the last record and I would like it to be at the top.
 

Answer:Access Data Base Continuous Form Sort

6 more replies
Relevance 65.6%

Hi, I created a form that allows users to filter records and with a click of a button displays filtered data in a report. If no filter is selected, the report shows everything. So far, it?s working as planned. However, I?m struggling to export the filtered data to excel. My attempt exports everything. Any suggestions?My form is based on MyQuery which consists of multiple tables.TIA,

More replies
Relevance 65.6%

Using Word2010 and Access2010, I am attempting to build VBA code that will automatically import word form field data directly into my database table.

I have copied code found on the net and modified very slightly.

I am pretty confident I have the word side of the puzzle setup corrrectly.
The Access side using VBA has ben throwing a number of errors.

I have modified the statement in
Code:
[COLOR=black][FONT=verdana]cnn.Open "[/FONT][/COLOR][FONT=Calibri]Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Users\XXXX\Documents\Testing .accdb;".[/FONT]
That got me a step past not being able to open the word file, assume that is correct. Not sure of the required references, but here is what is curently checked. I suspect there may be a mismatch between my provider statement and the references.

Visual Basic for Applications
Microsoft Access 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Access database engine Object library
Microsoft Word 14.0 Object Library
Microsoft Office 14.0 Object Library
Microsoft Visual basic for Applications Extensibility 5.3
Microsoft Active X Data Objects 6.0 Library
Microsoft Office Runtime 1.0 Type Library
Currently I am getting the error "424: Object required". No luck finding the source of this.

I attach that code below in hope someone has a tip that gets me moving again.

Code:
[/FONT][/COLOR]
[COLOR=black][FONT=verdana]Sub GetWordData()[/FONT][/COLOR]
[COLOR=black][FONT=verdana] Dim strDocName As String
... Read more

Answer:Importing Word form data into Access 2010

I am not familiar with your code, but I do have code that works, however it does require the use of a Word Doc with "Bookmarks" set.
 

2 more replies
Relevance 65.6%

My form in Access no longer displays records from the table. All records are still in the table. New entries show up in the table, but are not retained in the form. When I check form Properties, it indicates that the record source is that particular table. Any help appreciated.
 

Answer:Solved: Access form no longer displays data

Check that the form's property "Data Entry" is NOT set to yes as this restricts the forms action to adding new records only.
 

2 more replies
Relevance 65.6%

Okay, I've got an Access 2003 database. For this particular task I have a form with 3 comboboxes and a textbox, all four unbound. The data on the comboboxes are populated (RowSource) from three separate queries, which run fine. I have a button which, when clicked, I want to take the information and add it to a table (tData). My SQL is very rusty and I can't get it working right. Here is the SQL statement...

Code:
INSERT INTO tData ( CowType, CowLocation, CowMovement, [User], [Date], CowValue )
SELECT Forms!fData!CowType AS Expr1, Forms!fData!CowLocation AS Expr2, Forms!fData!CowMovement AS Expr3, CurrentUser() AS Expr4, Date()+Time() AS Expr5, Forms!fData!CowValue AS Expr6
FROM tData;

As you can see, the form (fData) should take the controls and add the value of each to the respective field in the table (tData). It's not working though, and I'm getting the retarded "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'". Can any Access/SQL guru tell me what I'm doing wrong? Driving me crazy here.
 

Answer:Solved: Access 2003: Add data to table from form

Nevermind, I got it. Went away from the Append query I was trying and did it via VBA...
Code:
Dim rsData As ADODB.Recordset
'Create data set for entry into table
Set rsData = New ADODB.Recordset
rsData.Open "SELECT * FROM [tData];", CurrentProject.Connection, adOpenStatic, adLockOptimistic
If rsData.Supports(adAddNew) Then
With rsData
.AddNew
.Fields("CowType") = Me.CowType.Value
.Fields("CowLocation") = Me.CowLocation.Value
.Fields("CowMovement") = Me.CowMovement.Value
.Fields("User") = CurrentUser()
.Fields("Date") = Date + Time()
.Fields("CowValue") = Me.CowValue.Value
.Update
End With
End If
rsData.Close
Set rsData = Nothing

 

2 more replies
Relevance 65.6%

Hi,

i have just created a search form. I will select a job number from the combo which displays my results on a form.

Now what i want to do is have a button on the search form when pressed it transfers all that information to my invoice form to the corresponding fields just leaving me to fill out the payment side of things.

If anyone could help me with the VBA i will be greatful. Thanks in advance.
 

Answer:Solved: Access 2003 transfering data from one form to another

6 more replies
Relevance 65.6%

I have created an on-line form in an Office application to gather survey data, and need to link it to an Access database. What is the easiest way to do this? Can I use a word document formatted with fields? Can I use a form created in Excel? How do I create a web based form that will be linked to the database? If anyone can answer one or all of these questions, I would be most greatful.

Thanks
 

Answer:Linking data from a form in another application to an Access database

Access 2000 has a new feature called Data Access Pages that are designed for displaying data on an intranet or internet. They would probably do the trick for you.
 

1 more replies
Relevance 65.6%

I am trying to built an application to display the availability of data from different tables in a form of calendar.I have a table A, B, C.Now, I will have to display data availability on a certain date.if A, B and C are available display the date in the calendar as Green.if only A is available, then display the date in Orange and like wise.Kindly assist.
 

Answer:Access form to display data availability like a calendar

7 more replies
Relevance 64.78%

I've made a button on a form which, when pressed, adds 1 to one field and adds 7 to another.

The problem I am having is selecting which record this applies to.

I am wanting for the button to apply to the record on display in the form.

I've been able to get the number of the current record into a variable lngrecordnum but am unsure how I can use this to select the record I want to edit

Any help is much appreciated. My code is below:

Sub CallMade()
Dim dbs As DAO.Database
Dim rstQuotes As DAO.Recordset
Dim lngrecordnum As Long
Set dbs = CurrentDb
Set rstCustomerQuotes = dbs.OpenRecordset("Quotes Table")

lngrecordnum = Forms![Quotes Table Form].CurrentRecord

'Select which record here

rstQuotes.Edit
rstQuotes!Call_attempt = rstQuotes!Call_attempt + 1
rstQuotes!Priority = rstQuotes!Priority + 7
rstQuotes.Update
End Sub
 

Answer:Solved: Access edit data of currently open record in a form

8 more replies
Relevance 64.78%

Hello -

I have a data table that is recording inspection dates and inspection purposes for specific records. There are a total of six occurences (i.e. Inspetion Purpose (1), Inspection Date (1), Inspection Purpose (2), Inspection Date (2)).I would like to use a form to input data into the fields. Is it possible to build an expression so that the data input into the form inserts the data into the table with the first available null value for that record.

In other words, if there is a value present in Inspection Purpose (1) & Inspection Date (1) then the data from the form is inserted into the fields for Inspection Purpose (2) & Inspection Date (2).

I would greatly appreciate any help!
 

Answer:Solved: Access: Inserting Data from a Form Into Fields in a Table

10 more replies
Relevance 64.78%

Hi all,
Not a huge tech head so tread lightly with me
I've recently designed and have been using a database for tracking of research participants. I have my backend and frontend separate (as per my husband's instructions )
I have 2 buttons on my switchboard. One for enter new participant. That form can enter new data and doesn't show existing data. My other button/form is "edit existing participant" - i had to make some changes to it yesterday - add new fields, move stuff around etc etc. was having probs as computer kept shutting down etc. However, all going well but end of day open it up and the 'edit participant' form no longer shows any existing participants/data. It's all still there in the backend but wont' show up on the form.

1. My data entry is set to No - so that's not the problem.
2. The data/record source is correct.... and all tables have been linked correctly between back and front ends.

Help please - this is work i've been doing casually for my old organisation and they desperately need this and I've mucked it up!!! Aaaagh.

Thank you
Carla
 

Answer:Solved: Access Form no longer reading data from table

6 more replies
Relevance 64.78%

Access 2007.

Main form works

Subform works

When I drop the subform into the main form they aren't linking.

Now I know this is a relationship issue. Everything was working fine until I had to update the subform and then put it in the main form again.

I am dead positive this is a master-child issue but I don't recall how I corrected it before.
 

Answer:Solved: Access Data - Form With Subform -Master-Chjild

16 more replies
Relevance 64.78%

I would like to create a Form (if that is what is used) that will allow an end-user to query data from a table (or query). In other words, the form will allow the person to enter or select more than one set of criteria...

I have seen this done in other databases... Usually, there are "and" and "or" options that allow the end-user to select more filtering options.

Since my next question is a simple one (I hope), I'll add it here instead of a new thread:

In a user-level security database (Access 200), is there a way for me to be able to see which users are currently using the system? Sometime I want to perform maintenance on my database, but I have to call all of the users to make sure they are not using the system so I can open it exclusively.
 

Answer:Microsoft Access 2000: Create A Form That Queries Data

13 more replies
Relevance 64.78%

In MS Access I have two tables for Equipment a Cost table and a Meter table.
I created a qry to link the serial number from the two tables.
I want to use a split form where I can enter data in either place ( on the form or on the datasheet below).

1 - Form is not allowing me to update it seems "frozen"
2 - I need to choose the Year.
3 - I need to choose the Area .
4 - After I have the Year and Area enter Cost or Meter.

Help ~ anyone out there with ideas that can help me I need step by step ~~ I'm super frustrated !!

 

Answer:Solved: MS Access 2007 help with split form to enter data

GIRLPWR, welcome to the forum.
How are the 2 tables linked?
Can you have more than 1 meter record per Equipment a Cost table record?
How are the tables joined in the query?
Why use a "Split" form?
 

1 more replies
Relevance 63.96%

Hi,
I want a user to click a button. It will ask for record number and then display it. User can then modify or delete or any other operation he want to perform.

Now I try to accomplish this by using wizard but when I select open the form and select specific data to display it give me a message that:

The Forms you have chosen cannot be linked you must have at least one feild that can be linked on each form.

What should I do? What am I missing?
mhadi
 

Answer:Access: Open a Form And Find for specific data for display problems

Have you tried putting a combo onto the for that will look up records?

But anyways you start with a form that will be the one that selects the records you want to display. The form that you want to open needs to have a related field so that Access knows which record you want to display. That is what you are missing.
 

3 more replies
Relevance 63.96%

Hi, I have a Form created with a text box called "SoldTo_Text"; the user will input multiple SoldTo numbers; I then want the query that is pulling from the "SoldTo_Text" box to bring back data for those multiple SoldTo's. For Example, user inputs 3 soldTo's (1111,2222,3333) then the query takes those sold to's and returns the other values I have set in the query, we'll say they are percentages, so then it would look like (spaces indicate new columns):

1111 3% 5%
2222 6% 8%
3333 8% 3%

Currently, my query works great when they input 1 soldto, but as soon as I try to put in another soldto with it, it doesn't work.

Any help is appreciated. Thanks.
 

Answer:Access 2007 Query a list of data from a form user input

11 more replies
Relevance 63.96%

If I wish to append the current record on a form there seems to be only two ways. One is in the append query for the table to leave all criteria blank in which case all records are appended not just the current record. The second is to enter a parameter value in the append query for the table which just deletes one specific record.
For each record on a form I can have a number of different records and I want to be able to append those.
Would appreciate some help here. Thanks
Richard
 

Answer:Solved: Append all data from records returned on form Access 2003/7

See my response to your other Thread.
 

1 more replies
Relevance 63.55%

I have a table with a field called "current fund balance" which is intended to be a data entry field. I have a query with multiple calculated fields. Both the table and query share a common field. I'd like to have a datasheet form to where data from the query and table are combined and have that field "current fund balance" be a data entry field. I'm having the hardest time figuring this out.

I've read a form/subform would work but I need to be able to see all the records at once. And so, datasheet with all fields would be best. Anyone have any thoughts?
 

Answer:Solved: Having a form field in Access to enter data based on a query with calculated

16 more replies
Relevance 63.55%

Hello!

I am a relatively novice user of Access 2007. My knowledge ends when I go beyond using a template. However, I am attempting to create a database from scratch for my job. I have encountered numerous issues, but easily found some solutions.

Unfortunately, my recent problem doesn't seem to have a current forum. I have created a database that contains 7 tables. From that, I created 2 forms, 1 subform, and 1 query. The intent of one of the forms is to allow general users of the database the ability to input data that will populate the fields of all tables, forms, and queries. However, the form is only populating the data into the 7 tables, not the other form or the query.

I hope to create more queries and some reports that will be generated off of the information that users input into the main form. Please help me determine what I need to do to ensure that general users can easily input data.
 

Answer:Can you create a form in Access 2007 that inputs data into all tables/queries/forms?

16 more replies
Relevance 62.32%

I have a form to update the hardware of a PC for an asset database (see image attached), it features a main form which shows the current information for that computer and a subform which creates a new record for that PC with all the new information. The problem is that when i enter new information into the subform and click onto the main form it automatically creates and saves the new record which is what i want to stop.
I would like the subform to save/cancel the data entry through the save and cancel buttons i have rather then it creating a new record automatically.
Any help would be appreciated.
 

Answer:Solved: Microsoft Access 2007-2010: Stopping Automatic Saving On Data Entry Form

8 more replies
Relevance 57.4%

Hi
I am a true beginner in access programming, so excuse if my methods isn't the best, and any advice would be much appreciated.

My main problem is displaying a Query I did on an attachment field in my main table on a form.
This is what i am working with:
Access 2007
My main table name : Table2
Attachment column name in Table2 : Target_photo
Query name: QuerySpecGraph (Query on the attachment field)

The query works perfectly fine when I run it and gives me the correct result. Now to display the query on the form I added an new attachment under controls and edited the control source to display the query results.

I used the function dlookup:

=Dlookup("Target_photo","QuerySpecGraph")

I tried similar code on a text box, with a text Query and that worked fine. However it does not want to work for the attachment.

Then I tried to analyze the situation to see if the query is the problem, so changed the attachments control source to:

=Dlookup("Target_photo","Table2")

this was to see if even a basic dlookup function works in the attachments control source, but yet again the attachments box stays empty (Again I tested the simple dlookup function with a text box to see if my table is the problem, but the textbox's dlookup works fine)

I do not know what I am doing wrong, or if it is even possible to do what im trying to do! Any advice would be much appreciated, and if there is away around this I will gladly explain in more detail ... Read more

Answer:Displaying an Attachment Query in a Form

12 more replies
Relevance 57.4%

Hi All,

Noob first-time poster I'm afraid!

I'm new to Access 2007 (but have used 2003 & 2000 reasonably extensively).

I'm building an App and have created all the necessary tables, as well as creating the relationships in the Database Tools area (which I know are correct - I'm a SQL Server DBA in my day job)!

Anyway, it's an almost text book example of an employers and employees database; one employer having many employees (employerID is the foreign key on the employee table).

I have created an employer form (using the wizard) which is fine, but then when I add a button to open the employee form (selecting 'Open the form and find specific records', matching employerID on the Employer table with EmployerID on the Employee table) it doesnt work. Instead, I get a popup box asking me for the EmployerID! Even if I manually enter the correct employerID when the popup box appears it actually displays all records, so I'm sure that the problem is more fundamental (and therefore, probably my fault)!

I'm hoping that I've just overlooked something REALLY stupid, but would apprecaite any suggestions!

Cheers,
Ian.
 

Answer:Access 2007 Form Button Wizard - Form does not open with the correct records

I have seen this kind of problem with Access 2007 VBA code which does not work when it dod in 2000-2003.
It can be a Syntax problem which you may be able to get around, if not you can get around the problem bby using a Criteria in the Query that supplies the Employee Form.
Although I would have thought it would be better design wise to have the Employees as a Subform or Tabbed Subform on your Employer Mainform.
I do not have Access 2007, only 2003 so I can't help with the VBA, but you could post the code anyway.

Did you use a Wizard to create the Employee Form, if so check the Record Source SQL it may be preventing your EmployerID from working.
 

1 more replies
Relevance 57.4%

Hi all

I have a simple Access (2003) db which has a single form view with a subform. The main form is a record based upon a physical case file the subform only details actions past and future, a sort of event log.

I also have a continuous form which displays all upcoming actions sorted by date on all cases for a particular user so they can see just how busy they are likely to be for a particular period. What I would like to do is have an on click() property for the detail of the continuous form so that it opens the main form filtered by the record in the continuous form that was clicked. User can then update or add new events for that case before closing form and returning to the continuous form

Hope this makes sense
 

Answer:MS access open single form filtered by selected record in continuous form

coasterman, welcome to the Forum.
It makes perfect sense.
If you add a Command Button to the Continuous Form and after selecting the mainform select the "Open the Form and find specific data to display". This will give you the code that you need to add to your On Click or On Double Click property or of course leave the button and use that.
 

2 more replies
Relevance 57.4%

Hello,
thanks for taking a look at this thread, any help will be greatly appreciated by a complete Noob.

I've been given a LOT of help by members of this Forum (especially OBP) with a DB I'm making as a first look at any type of IT product, and I'm very grateful, so thank you all.

Recently, I was advised to take a look at the "Tabbed" style of "MainForm" instead of the "Switchboard" style I originally used. I must say, I really like the tabbed style much more than the switchboard but I've hit one hurdle that I can't seem to overcome.

In the Switchboard style, I was able to set a form to load in either DATA ENTRY = YES or DATA ENTRY = NO mode depending on which sub-switchboard the user selected. For example, I had a ENTER NEW sub-switchboard that all forms would open in DATA ENTRY = YES mode & I had another EDIT EXISTING sub-switchboard that all forms would open in DATA ENTRY = NO mode.

However, with the new tabbed style, I cannot set the form load type for separate tabbs, it will only accept the LAST type as the GLOBAL type. Example, on the ENTER NEW tab, I set the form to load as DATA ENTRY = YES & sets the form to open in DATA ENTRY = YES on both tabs, then I go to the EDIT EXISTING tab & set the same form to DATA ENTRY = NO & it sets the form to open in both tabs in DATA ENTRY = NO mode.

So, my question is:
Can I set the same form to load differently on different tabs on the same MainForm?
If so, w... Read more

Answer:Solved: MS Access - Tabbed MainForm - How to make a form open a form in multiple mode

I would just copy the Subform, so you have version 1 for data entry with the Data Entry set to "Yes" and version 2 set to "No".
The only thing you need to do then is to Requery the Editing form each time you make an entry in the data entry form.
Although I prefer to just have an Edit form with a "New Record" button for the data entry.
 

2 more replies
Relevance 56.99%

My multi item form isn't letting me add new records, only update and delete current ones.

My guess it that this is because the form is based on a multi-table query. That's fine, I can make a new form specifically for adding new records, but I'd like to be able to salvage this form if possible. Is there any way to either force this form to accept new records in the bottom row, or is there any way to get rid of the "add record" bottom row completely so it's not misleading users into thinking they can add records here?

Thanks in advance.
 

Answer:Solved: Access 2007 - multi item form (continuous form) trouble adding records

16 more replies
Relevance 56.99%

Hello

I have a subform which on its own - works beautifully but fails under the mainform. I use a main form to select the record that the end user wants to update. Upon update event on main form, the sub form opens, presenting fields for possible updating. The Sub Form also present 2 buttons - Save & Close or Cancel and Close (Undo). When the main form opens, the code set AllowClose as False. When the sub form is opened as a result of the update on the mainform, the issue is the Close command /code gets canceled. (Error 2501). I have tried: 1. setting AllowClose (true and False) on both forms, 2. only the main form and 3. only the subform. None of these 3 configurations resolves the issue. Also, I tried moving the buttons to the mainform instead of the sub form but that failed as well.

The application has a dozen forms and all of them utilize AllowClose functionality so the end user MUST use the buttons on the forms to force background queries (updates, deletes, perform calculations, recalc control totals etc). This is the first time I have tried to use Allow Close on a subform with buttons.

XP and Access 2007

KEY ELEMENTS OF THE CODE:

Private AllowClose As Boolean

Private Sub Form_Load()
AllowClose = False
End Sub

Private Sub Form_Unload(Cancel As Integer)
Cancel = Not AllowClose
End Sub

Private Sub SaveChangeandCloseForm_Click()
AllowClose = True
DoCmd.Close

Private Sub CancelAddingNewRecord_Click()
If Me.Dirty Then
Me.Undo
End If
If Not Me.NewRecord Then
En... Read more

Answer:Action Canceled - Using AllowClose on Form and Sub Form - Access 2007

Why not just use a listbox to display the records based on the selection on the main form? I don't think you can actually close a sub-form on a main form since it is tied to the main form.
 

2 more replies
Relevance 56.99%

Morning Guys.

I am having a problem with Access 2007. I am not good with code, so would like to resolve this without using code if possible?

I have a form "A" that I have created. I want to be able to select a row on form "A" press a button and it will open a form "B" based on the selected record in form "A".

I have had a look at the button wizard, and it lets you have the option, but when you go through the wizard, it gives you an empty box on the left and a box on the right showing all the fields in the form "A". Nothing to relate to?

Any ideas?

Thanks
AJ
 

More replies
Relevance 56.99%

I have a database which ultimately will have a couple of thousand records. The primary table has 30+ fields. I have lots of queries and connected reports to show various subsets of the data needed from the table. However, there are times when what is needed is all fields for a specific subset. Because the records sought often need to be filtered by several criteria, I've found the "Filter by Form" option to work well. I have a button on the main dashboard marked "Find Record" that automatically opens a search form in the "Filter by Form" mode. This allows me to enter information into as many controls as necessary, and returns exactly the right records after clicking on "Toggle Filters" on the ribbon. The problem is that ultimately I need to make this "Access-free". The goal is to create an application from the database without ribbons. I've created a button to run the filter, and another one to print the results, but when the search form is open in the "Filter by Form" mode, it greys out the buttons. I understand that there is a GotFocus command or something similar. Can anyone help with specifics, both the syntax of the command and where the command needs to be typed? Thanks a bunch...I look forward to your reply.
 

More replies
Relevance 56.99%

Hi all.

I am using WebEasy Professional 6 to design my website. I have inserted a form on my 'contact us' where clients can submit comments, however these comments display in html format when I view it in my inbox (Microsoft Outlook). Does anyone have any suggestions to correct this? Thanks!
 

Answer:Form on website displaying comments in html

Greetings, BexBomb.

Sounds like you've got something missing, most likely a bracket. Look for code similar to this:

<form>yada yada</form

Notice the missing > after the second "form".

If you can't find the culprit, post the address and I'll take a look at it, or you can validate the page at w3.org which should show any HTML mistakes on the page.
 

3 more replies
Relevance 56.58%

Here is what I'm trying to do.

For lists Equipment in drop down box.
Whatever equipment that is select, the equipment type field needs to be updated from a table.

Is there a way to get a value from SQL statement?

SQL = "SELECT [Equipment Type] FROM OrderDetails Where " _
& " Equipment = '" & Me.Equipment & "'"
[Forms]![OrderDetails]![Equipment Type] = SQL
 

Answer:Help with access form (insert table value into form field)

Mhouser, if you are trying to "display" a value related to the Combo selection you can have thta value as an extra column in the combo and refer to it with simple VBA.
You should not populate a Field's actual value with that from the combo as that is duplication.
Can you tell me which one you are trying to do?
 

3 more replies
Relevance 56.58%

I am a new user to Access 2010. My operation system is Window 7.
I have created a data base with two tables. The first table contains a list of students and their personal information. The second table contains student subjects and has many subject records with a relationship to the student record. The relationship key is the student id.

I have created a form that populates with the student information and contains a subform that populates with that students subjects. All of this works great for existing students. I can edit the student information and and new subject records.

Now here is my problem. I would like to create a form that preceeds my current form. The user would input a student number and click search button. If that student number exists on the student data base then the form that I created should open populated with the student data and their subjects and allow the user to update it. If the student number does not exist, then I would like that same form (or a form with the same layout) to open and the only data populated is the student number that was input on the search form. The user should be able to input all of the student data and course information and hit a save button that would insert the records into the correct database tables.

I have tried many methods to create the intitial search form that would open the correct version of the student form without any progress. Could someone provide me with the macro that would open that correct form, or set t... Read more

Answer:Access query to open Add form or Edit Form

needaccesshelp, welcome to the Forum.
First a couple of points, you do not need to "save" the record, access does so automatically. Also when creating a New record the subform should be automatically populated with the Student Number, this is controlled by the master child links.

The combo you need is a Find combo which can be created using the combo wizard, that combo can have it's Not In List Property set to yes, which can then be used to trigger adding the student that to the table and then to the form (and combo).
 

1 more replies
Relevance 56.58%

Hi! I got this problem!

I have 2 forms. A main form and an extended form. I want to pass data from a field in the extended form to main form and save it in the main table. So the field's name in the extended form is: txtBDiluentLot, the name of the main form: BondSparF and the name of the extended form is BondDiluentF. I have written a code:

Private Sub StängKnappen_Click()
Me.Refresh
If IsNull(txtBDiluentLot) Then
'do nothing
Else
Forms![BondSparF form].Form.[BondDiluentF].Form.txtBDiluentLot = Me.BDiluentID
Forms![BondSparF form].Form.[BondDiluentF].Form.txtBDiluentLot.Me.SetFocus

End If

DoCmd.Close

End Sub

.... But when I run it it says: Run-time error: 2450

Microsoft Access cannot find the referenced form "BondSparF form".

Why I can't run it???

Thanks a lot!
 

More replies
Relevance 56.58%

In access, I have a field that connect to a popup form for selection and after selecting the data required, the data did not print in the field. How can I have the data in the popup form to be printed in the field.
 

Answer:Transfer data from a form to another form

aattas, welcome to the Forum.
Can you explain a bit more about what you are trying to do and why you are using a pop up form?
 

3 more replies
Relevance 56.58%

Hi there,

I don't have enough experience in VBA excel or word, and would you mind helping for the following:
Q1
The below macro code add row below the last row. And Would you mind telling me what is the code that can add row for word document table between the last row and the row before the last?

ActiveDocument.Tables(1).Rows.Add

Q2:
My second question is related to export/import between two different programs or files ( Excel and word document)
Would you mind providing me the proper code for
Wordtable.copy
Workbook.xls - sheet1.past speical value
Suppose the word tables excel workbookD sheet 1 are as follow

Table 1 in word document
--------------------
Cell 11 - Cell 12
Cell 12 - Cell 22
--------------------
Table 2 in Word document
------------------------------------
Cell 11 - Cell 12 - Cell 13
Cell 21 - Cell 22 - Cell 23
------------------------------------

WorkbookD.xls – Sheet1
Rows Column
A B C D
1
2 wt1.Cell 11 WT2.Cell 11 WT2.Cell 12 WT2.Cell 13
3 WT2.Cell 21 WT2.Cell 22 WT2.Cell 23

How I write a macro to make the value or text in Cell 11. in word table 1 to be copied and past in Cell A2 in sheet1 of WorkbookD.xls
and the value or text of the range from Cell 11 to Cell23 of table 2 or word.doc to be copied and past in sheet1 of WorkbookD.xls from range B23 for n rows in table1 and table 2 of word.doc.

Thanks

Hamdy"
 

More replies
Relevance 56.17%

Computer:Del Vostro 430 runing Windows XP Pro Service Pack 3, Comodo Firewall, AVG Free.Following a malware infection (now cured, see http://www.computerhope.com/forum/index.php/topic,134485.0/all.html) I have a strange problem with Windows Files Search.  These two images show the Windows Files Search launched from Start > Search > For Files and Folders, and from Windows Explorer > SearchAs shown, the search form at the left is not displaying properly.  Somehow it is scrunched up vertically so that only a tiny part of the actual form can be seen.  The scroll bar of the form still works and I can get to all parts of the form but to use it is like doing keyhole surgery.  Also, the link for the alternative Search Assistant (the ?cute? puppy) is missing.What in the world could be causing this behaviour?  Any ideas are welcome.Keith

Answer:Windows Files Search form not displaying properly

Do you have your XP CD ? ?If so...from a command prompt type in sfc /scannow and hit Enter...let it finish and re-boot...The cute Puppy may even come back...

2 more replies
Relevance 56.17%

Hello.

I wonder if you can help me with something. I have created a Form where there are 4 drop down boxes that collect data from 3 tables. How can I use that form to search for all the records matching one or more criteria chosen from those drop down boxes and display other fields on a report or a table?

The case is:
Tables

Table_Candidates (number of candidate, name, date of birth, address,…)
Table_Professional_Habilities (professional experience, years on the job…)
Table_College_Observations (College attended, degree, years, field of expertise…)

Form – Drop Down Boxes

Professional experience
College attended
Degree
Years
Age
Result Expected (How do I get this? In a table or a report, it doesn’t make a difference)

Number of candidate
Name
Professional Experience
College Attended
Degree
Field of expertise
Age (how can I calculate this from date of birth?)

I've been advised to use Expression Builder. But the query isn't working because itreturns blank. Should I only select the fields on the Expression Builder (as an example, this is what it appears " [Forms]![New_Frm_Parameters_Selection]![Combobox17] "? Or should I make another expression?

Thank you very much.
 

More replies
Relevance 55.76%

I built a form called PO Log that contains input text boxes that the user can enter the different iputs that will add an existing row to the worksheet called PO_log. I have the add function working perfectly. But I want to add a function to the form that if the record/data already exist using the PO number as an identifier, to udate the existing record/data rather than adding a completely new row of record/data. Here is the code I have below for the adding function.
Code:


Private Sub cmdAdd_Click()

Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("PO_log")

'find first empty row in database
iRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row

'check for a part number
If Trim(Me.txtVendor.Value) = "" Then
Me.txtVendor.SetFocus
MsgBox "Please enter a Order Info"
Exit Sub
End If

'copy the data to the database
ws.Cells(iRow, 1).Value = Me.txtVendor.Value
ws.Cells(iRow, 2).Value = Me.txtPONumber.Value
ws.Cells(iRow, 3).Value = Me.txtPurReqDate.Value
ws.Cells(iRow, 4).Value = Me.txtRFQSent.Value
ws.Cells(iRow, 5).Value = Me.txtSentToVen.Value
ws.Cells(iRow, 6).Value = Me.txtDateOfPo.Value
ws.Cells(iRow, 7).Value = Me.txtOrderConf.Value
ws.Cells(iRow, 8).Value = Me.txtAmt.Value

'clear the data
Me.txtVendor.Value = ""
Me.txtPONumber.Value = ""
Me.txtPurReqDate.Value = ""
Me.txtRFQSent.Value = ""
Me.txtSentToVen.Value = ""
Me.txtDateOfPo.Value = ""
Me.txtOrderConf... Read more

Answer:VBA: Excel form that updates current data or add new data

Closing duplicate.
 

1 more replies
Relevance 53.71%

This ought to be pretty simple to do. I have a small table that contains contact information for a number of businesses: name, address, etc. I have an “ID” field that is an auto number and is the PK. I have created another table that contains the business name, date of a donation and a memo field to hold the donation info (since it’s stuff instead of money.) In the second table, “ID” field is also an auto number and is PK. I have related the tables with a one to many: theoretically one business with many possible dates/donations which is the basic premise. I created a main form to input the business data and created a sub-form for the donation data based on their respective tables. Each business will be unique but a business may give multiple donations, say one each month or more – whatever.

I can’t get it to work. I’ve got that big, honkin’ Access 2000 Developer’s Handbook but am still getting up to speed using it…. but I’ll keep looking until I hear from someone!

Thanks.
 

Answer:Access 2000 Form/Sub-form

9 more replies
Relevance 52.48%

I want to create a form in a sort inbox style so i ahve a list of records at the top in a datasheet and then by clicking on the list the details should show up in colunmar view below.

Sound simple its not.

I can get it to work the other way round by having a datasheet subform in my main form but thats not much use.

What i need to do is to somehow reverse how the form subform relationship works.

Any ideas?
 

Answer:Access: Form with subform datasheet. Selecting record on datasheet shows in form.

12 more replies
Relevance 51.25%

Hi everybody, when i have created a report using a tool called Jreport Designer.It shows the data well in html and pdf format.but when i export the same to excel then for few fields its showing ########.We know that the data would be changing dynamically ,whenever the value is huge then its showing #######.could anybody knows how to resolve this issue.Thanks in advance

Answer:excel displaying ##### where the data is big

Increase the column widths of those columns that may have large numbers. This will probably spoil the appearance of the spreadsheets with normal data.

2 more replies
Relevance 50.84%

Hi,
I've developed a database in Access 2010 and am using the Navigation Form for users to access the different forms and it's working very well. The problem is we still have some workers who are on Windows XP boxes with Office 2007 and the Navigation Form won't work for them. I've been asked to develop an Access 2007 Switchboard which will mimic the Navigation form so there is some continuity between them and so that once all the systems have been upgraded the users willbe familiar with the interface. I easily designed a form with the look or the Navigation Form but haven't been able to figure out how to handle opening the different subforms on the one main form. Is it possible to place an Unbound Frame on the form and with a click of a button open a subform in the Frame or have a button just open a subform? How would that be coded?

Thanks for your assistance
 

Answer:Solved: Access 2007 Switchboard & Access 2010 Navigation Form

I am a bit confused because Subforms normally open when a mainform opens.
I am not familiar with the Access 2010 navigation form so I am not sure what you are trying to do.
 

2 more replies
Relevance 50.43%

I have no idea why, but all of a sudden Windows Media Player (current v11) is displaying a bunch of information the upper left corner about the video stream being played. It only does it on some videos. I've searched high and low for a setting to stop it but can't find anything. I've also downloaded the installer from MS and reinstalled it.

Driving me crazy -- any advice most appreciated.

Brian
 

Answer:WMP displaying data on screen (want it to stop)

7 more replies
Relevance 50.43%

I've entered an expression in a table field that will display the right mileage rate dependent on the post code entered and the type of vehicle used. The idea is that if a car is going from the BH post zone then I should automatically see the £1.15 rate and a MPV leaving from the GL zone should display the £1.40 rate.

The problem I have is that when I show the table none of the MPV rates are displayed other than the "SP" and "SN" which both happen to be the last post zones in the individual IIF statement and happen to precede the AND statement.

The actual expression is below:

IIf([Post Zone]="BH" Or [Post Zone]="SO" Or [Post Zone]="PO" Or [Post Zone]="SP" And [Veh Type]="Car","£1.15",IIf([Post Zone]="BH" Or [Post Zone]="SO" Or [Post Zone]="PO" Or [Post Zone]="SP" And [Veh Type]="MPV","£1.20",IIf([Post Zone]="BA" Or [Post Zone]="BS" Or [Post Zone]="GL" Or [Post Zone]="SN" And [Veh Type]="Car","£1.35",IIf([Post Zone]="BA" Or [Post Zone]="BS" Or [Post Zone]="GL" Or [Post Zone]="SN" And [Veh Type]="MPV","£1.40",""))))

Where have I gone wrong? I have got more post codes to enter but I won't bother yet until I can get this fixed. I have contemplated creating an Update query to automatica... Read more

Answer:Multi IF expression not displaying all the data

Jerry Tack,

What program are you using?

Stoneboysteve
 

7 more replies
Relevance 50.43%

hi,i am currently doing a small web project that uses a MySQL database and PHP.i have a table set up with a list of products that has the main headings:ID, Name, Brand, Category, Spec, Description and Price.my current problem is that i want a seperate part of the site for each category.i have figured out how to display the whole table of products in one big list using$data = mysql_query("SELECT * FROM product_db") or die(mysql_error());and then printing it into a table but cannot work out how to display a select category of data or even sort the long table by category , name or price.any ideas?Regards

Answer:MySQL Displaying select data

OK, teach yourself SQL is to big a topic for any post :-)However, although I don't know MySQL and PHP, I can probably give you some general SQL pointers. 1) To return a subset from a table, you need to USE a WHERE clause e.g SELECT * FROM FRUIT WHERE FRUIT_TYPE = "TROPICAL"The above SQL will return all records from the table "FRUIT" where the column FRUIT_TYPE = "TROPICAL" (not "tropical" or "Tropical" since SQL is case-sensitive)2) WHERE clauses can be concatenated and/or wild carded e.g SELECT * FROM FRUIT WHERE FRUIT_TYPE = "TROPICAL" AND FRUIT_COLOUR = "GR*"Check what the wild card character is in MySQL because it can vary between different types of SQL3)To sort returned results use the ORDER BY clause e.g. SELECT * FROM FRUIT WHERE FRUIT_TYPE = "TROPICAL" ORDER BY ORIGIN_COUNTRYThe above SQL will cause the returned results to be sorted by the contents of the ORIGIN_COUNTRY column in the FRUIT table.These are the simplest forms of these functions and much more sophisticated constructs are available. I suggest you google for "basic SQL" which returns a number of good intros to SQL.Like I said, the above a general SQL principles and I normally work with Oracle not MySQL. However, they should give you a hint as to where you need to look in the MySQL docsGood luck

3 more replies
Relevance 50.43%

Hi Help please: I cam/cord my two youngest Granddaughters moriss- dancing each weekend throughout the summer?[ I also do the other troupes to help the trainers identify any faults?I encode the finished film normal run around 1 hr. onto the PC using Neo/DVD into MP 2 Then Transcode to video format to put on to DVDs.Question? How can I ripDVD into DATA form to go on to a CD without losing the quality of Film!Syd.

Answer:How can I rip "DVD" into DATA form to go on CD.

Why do you want to put them on cd ?Why not just copy the dvd in Nero ?Free dvd to vcd software click here

2 more replies
Relevance 50.43%

Hi All,

I am trying to put a combo box on a form that will allow the user to both scroll through the list and start typing the first name of the employee to find the desired name. Clicking on the desired name would open the appropriate record.
So far, I have successfully created:

A 'multi column' combo box, that shows the information that I want, called "cboSelectBEP"
The combo box lives on a form called "Basic Employee Profile"
The combo box is fed from a query called "Basic Employee Profile Query"
All the main data is kept on a table called "Employee Information"
What I seem to be missing is the following functionality:

The combo box shows the test record (ie the list) when you click on the arrow but does not allow you to type the employee's name in to search
When you do click on the test record, it doesn't actually go to any record - other than the default record - btw - how can I change that so the form comes up blank?
I think part of the issue lies in the fact that my query takes the First & Last names from the "Employee Information" table and puts them together in a 'full name' format. I know the topic of comboboxes with 'search while type' functionality has been covered many times before but I've been searching the internet for 3 days and can't seem to find where I'm going wrong! Any help is appreciated!

To make it easier envision the situation with the... Read more

Answer:MS Access searchable combo box on form to access records

It is a property setting on the form that is causing the problem.
I have added a find combo to my form in your original database that works fine.
 

1 more replies
Relevance 50.02%

20/04/07 Please see below.

I have a Userform which collects a Product identity and other information which is all stored correctly in the spreadsheet it supports. I need to break into the Userform after Product is entered, to find the product in a separate spreadsheet (it will be there) and retrieve its price, which I then want to display in a new text box on the userform.

I have everything else working, but I cannot find a way to get the price data to appear, before going on to enter the remaining fields. I have set ControlSource for the price field = to its cell address, and I have confirmed that it is there. I have tried reissuing Form.Show but this causes an error, and Form.(next) Item.SetFocus but this seems to have no effect.

Any help will be very gratefully received.

20/04/07

I have solved the problem - part an error on my part and part more experiment and learning. I apologise to those of you whose time I have wasted.
 

More replies
Relevance 50.02%

I was given a HAICOM HAI-303III GPS which has no display. It is a unit which sends serial data in NMEA-0183 format to a receiver-display.

I have connected to the serial port of my laptop and with Hyperterminal configured at 4800 baud it receives and displays correctly NMEA-0183 data sentences like $GPRMC, $GPGGA, $GPGSA, GPGSV and others which contain information regarding position, speed, course, etc.

Examples:
$GPRMC,093721.239,A,4026.2880,N,00341.7718,W,022.4,084.4,190108,,,A*68

Where:
RMC Recommended Minimum sentence C
093721.239 Fix taken at 09:37:21 UTC
A Status A=active or V=Void.
3026.2880,N Latitude 30º 26.2880' N
09341.7718,W Longitude 093º 41.7718' W
022.4 Speed over the ground in knots
084.4 Track angle in degrees True
190108 Date - 19 Jan 2008
003.1,W (Empty fields) Magnetic Variation, W
*6A The checksum data, always begins with *
$GPGGA,093722.238,4026.2426,N,00341.7677,W,1,05,24.7,715.4,M,51.7,M,,0000*7F

Where:
GGA Global Positioning System Fix Data
093722.238 Fix taken at 09:37:22.238 UTC
3026.2426,N Latitude 30º 26.2426' N
09341.7677,W Longitude 93º 41.7677' W
1 Fix quality: 0 = invalid
1 = GPS fix (SPS)
2 = DGPS fix
3 = PPS fix
4 = Real Time Kinematic
5 = Float RTK
6 = estimated (dead reckoning) (2.3 feature)
7 = Manual input mode
8 = Simulation mode
05 Number of satellites being tracked
24.7 Horizontal dilution of position
715.4,M Altitude, Meters, above mean sea level
51.7,M Height of geoid (mean sea level) above WGS84 elli... Read more

Answer:Acquiring GPS data via serial port and displaying it.

Hi GS3,

Searching for GPS display software +open source, I came across The GPS Toolkit &#8211; Open Source GPS Software here. The link is to a PDF (9 page) paper download with links in it regarding the kit. It works on Linux, Solaris, and Windows according to the paper. Open source software is free for personal use.

See Open Source GPS Home Page

-- Tom
 

2 more replies
Relevance 50.02%

Is there a way I can scan the keyboard for data that will be entered into a cell I have the cursor on when I look at the graphic? In other words, I want [while looking at the graphic] to be able to change a variable in a particular cell from, say value 1 to value 2. This would then cause the sheet logic to generate different outcomes, and the contents of the graphic would change. Right now, I have to go back to the sheet, type in a 1 or a 2 in the cell, then go back to the graphic.

Another alternative would be it I could click on something in the graphic that changes the value in the sheet.

Thanks,

Don
 

More replies
Relevance 50.02%

I have used the search option prior to making this new thread in order to find an answer to my question but I couldn't quite find what I was looking for.
Here is my problem.

I've made a website in PHP in which it is possible to search for data which is stored in a phpMyadmin database. This data is categorised in several different categories.

I have also made a seperate page which is only accescible by password.
What I'd like to do is to make it possible to add more data to the database from the website itself (after having logged in with the password) via a form.
The whole logging in thing works just fine but I haven't got a clue how to make it possible to add more data with a form.

So far this is a script I have found and used but it doesn't quite work:


PHP:

<? 

$hostname "locahost"
$username "235301"
$password "235301"
Read more

Answer:Data entry through PHP form

To see what's going on, you can try temporarily putting error_reporting(1023); at the top of the PHP code and removing the @ sign to display all errors/notices. If you still get nothing, the script is probably not being run. Perhaps the session is not being propagated correctly? It could also be some other technicality. (I did notice the $genre line was not completed.)
 

3 more replies
Relevance 50.02%

Hello, I am trying to copy data (fields) from one form to another and I found a VBA code as follows:

Create the command button on the form and double-click it in design mode.
You now are the VBA mode for that button in the click event.
Simply add all the fields in this form:
Anotherform![fieldname] = Me![fieldname]

I tried but im getting the following error message:

"run-time error 424

object required.

Help!
 

Answer:Copy data from one form to another

Before I try and answer the VBA question can I ask why you want to do this?
As copying data is not supposed to happen in Relational Databases, data should be referred to.
 

1 more replies
Relevance 50.02%
Question: Data form Browser

I am looking for some sort of program that can be used to control a web browser. I wish to take data from a web site and then manipulate it and then use the manipulated data to: insert data, press buttons, refresh the page etc.

Can this be done without any real knowledge of any programming? What sort of software can do this? Is there software available for download that can do this?
 

Answer:Data form Browser

If you use Firefox as your browser, there are extensions you can use, see: https://addons.mozilla.org/search.php?q=greasemonkey&app=firefox
 

1 more replies
Relevance 50.02%

I recently did a cleanup on a users laptop, effectively nuking all of his form data to a miriad of websites he had usernames/passwords saved for. Not a happy guy right now.
He has a desktop that has all of this data intact. Any way I can "export" this data back to the laptop ? Not sure if the data is stored in reg keyes or temp files on the HDD.
User is running IE on both systems. He actually running Firefox as well... form data on desktop is also intact. Need to get that exported too... but one thing at a time.

Any help would be GREAT !!!

Keith

More replies
Relevance 50.02%

I've researched this far and wide, and I have yet to come up with a solution.

I recently did a series of password updates and changes to various forums and websites I usually go to, but in the midst of my mass changing (my old email was somewhat comprimised so I changed most of my personal data) I have forgotten a few of my new passwords and "secret question" for security purposes.

My question is if there is a way for me to view / browse the web form data I had SENT from my computer to retrieve this information? I'm not exactly where to look for programs / information to do this, is it under Post Data, Web Forms, in my cache, history...I'm lost

I'm the idiot that never enables "remember this password" for auto-complete, so I'm thinking the outcome may be dim.
 

More replies
Relevance 50.02%

I am designing a website where the user enters data in a form, and this data is then used to access / retrieve records.The data is simple, - forenames and surname.I am trying to find a data validation routine (using Javascript) such thata) the surname can't be blankb) the surname must be alphabetic, - plus a wildcard symboland c) the surname must be more than 3 characters long.Can anbody PLEASE recommend a routine that WORKS.I have tried one in "Learning PHP & MySQL" by Davis and Phillips which DOESN'T work and trying to make it work is driving me nuts.

Answer:Data Form Validation

You should never validate form data by JavaScript. Depending upon how it is coded, around 10% of your visitors will find either a form that fails to function or a form that is not subject to any validation. If the latter is the case, it obviously presents a very easily utilised and serious security flaw to any malicious user, who simply needs to disable JS....If you don't want to or cannot write your own PHP program that includes validation, that's understandable, but there 'net is full of resources for off-the-shelf PHP form processors. A few of which are actually very good. click here for one of them or search through Hot Scripts, etc. Even a basic array check that exits the program when bad words* are found is better than nothing. I have posted that before but I can do so again if you wish.*Bad words, in PHP, does not refer just to foul language but to any content that you wish to block.

6 more replies
Relevance 50.02%

The names, email addresses, and scrambled passwords that I use in my logins
and forms have suddenly disappeared. I am now compelled to retype the whole
ball of wax each time it's asking for it. Has a check-mark somewhere gone
astray?

I can't find anything under Tools > Internet Options > Advanced.

Dieter
Sacramento, CA (USA)
 

Answer:Login and Form Data

Hello have you used any programs to remove temporary files ?
 

2 more replies
Relevance 50.02%

Hi all,I'm looking at the possibilities of setting up a webform using dreamweaver.It's currently in the form of an Excel spreadsheet. It's simply a change control register. When something needs changing on a process it needs to be logged.The user will input into a form and then submit. On submitting the contents of the form would be displayed as a table (register) which anyone can view on the page.The type of fields required would be:drop down lists to choose fromdatestext field (used for job description)link to relevant job folderlinks to related job foldersa boolean option of some sort (probably yes/no)a number of other text fieldsIf anyone can give advice that'd be great. Otherwise it's either keeping it as an Excel file or having a go building standalone in Java.Thanks all

Answer:Data Form using Dreamweaver

It seems to me that you should be designing a database to drive your webpage (site). The form would be used to update the database and your display page would be generated by the database. Dreamweaver Help can get you started if you look at 'Developing Applications Rapidly'. Will the users be remote, which is why you are going down the webpage route? Will it be an intranet for your office?

2 more replies
Relevance 50.02%

I have a very large file that records our staff Annual leave and other absences. but all the information has to be entered by me, when people request leave via e-mail or via paper leave forms.
I would like to be able to automate this, the best way would be for a form to be sent via e-mail. If it could some how then update my existing data base this would be great.

Andy body out there who can help

Please
 

Answer:EXCEL: Add data from a form?

8 more replies
Relevance 50.02%

I have been working on this for most of this week and I cannot figure out the SQL code in Access 2007. I have a table called Agent_List and a table called Matrix. I have a form to fill in data from the Matrix table but I want to lookup a PBXID and have the First Name and Last Name fields on the form automatically fill in.

Can someone help me?
 

Answer:Form - Automatic Fil in Data

7 more replies
Relevance 50.02%

Does anyone know where IE's auto-complete form data is stored in the registry??

I want to be able to make a batch file/registry file to clear the contents during the logon process but don't know where the details are stored.

I'm not referring to the typed URL's...just the form data, like the drop down lists from search boxes.

i think the following keys are involved but not too sure:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\RNG
HKEY_USERS\*******\Software\Microsoft\Windows\CurrentVersion\Shell Extensions\Cached

Any help would be cool :)

Answer:IE AutoComplete Form data...

*bump*

Does anyone out there know the answer please????

Further to my previous post, i'm not sure that those registry keys are relevant at all.....I took a snapshot of the registry before clearing the autocomplete data and one afterwards and then compared the two and those two keys were modified but I repeated the process and it was different so i'm even more confused now

7 more replies
Relevance 50.02%

can i clear just one field or is it all or nothing ?
thx
 

Answer:ie8 - how to clear form data

6 more replies
Relevance 50.02%

Cannot save form data in IE7&8

Windows XP SP2 IE7 latest SP
Windows XP SP3 IE7 latest SP
Vista Ultimate SP1 IE7 latest SP
Vista Ultimate SP1 IE8 Beta 2
The PC in question went through the above migration and at no time
did AUTOCOMPLETE ever work.

The AUTOCOMPLETE checkboxes are indeed selected under CONTENT TAB
and ADVANCED TAB in IE options page.
Autocomplete web addresses works.

Computer history -PC was made from corporate image and I suspect a
very very special and well hidden group policy may be enabled.
Examples: Autologon disabled and remeber NTusername for Windows
logon were disabled. That stuff was easy to find and fix.
Tried so far.
Removed IE7 and IE8 numerous times.
Cleared TEMP internet files
Rebooted after changes
Cleared save autocomplete options cleared password and form data,
rebooted.
Turned autocomplete on for all 3 fields.
Reinstalled IE7 many times. Upgraded to IE8.
Removed IE8.
Reinstalled IE 8.
It just won't save any form field in any web page I visit.
I browsed for an hour Group policy, found internet explorer in two
places (computer and user) everything set NOT CONFIGURED.
Nothing found in LOCAL SECURITY POLICY either.
I even added a new user added to ADMIN group and that person has
same issue also. So not applicable to my admin username.
The only clue I have is the following
In the registry in
HKCU\Software\Microsoft\Internet Explorer\Intelliforms
there should be 3 subkeys
SPW
Storage1
Storage2
On a PC that does work IE8 XP SP3, th... Read more

More replies
Relevance 50.02%
Question: Deleting Form Data

In XP under Tools, delete browsing history. On clicking delete you are presented with several options, one of which is delete Form Data. This gets rid of names/words you've previously used in search boxes. Like Google for example.This worked on my previous comp but won't work on my present one.Has anyone any idea as to what is stopping it from deleting?

Answer:Deleting Form Data

Are you using Internet Explorer?

7 more replies
Relevance 49.2%

Hi, I had excellent help the other day when I was talking on this forum, so I decided I would try it again. I have been searching for a way to auto-populate data into a new form.

What I am doing is I have a form that is called Invoices. I have a combo box called Customer Name. I have it set so it pulls the customer names from my Customer Information Query. I have it set to Inherit value list. (I have never used this before) Anyway, it works great except that when a person enters a new customer name that is not in the value list, it will prompt you to add the customer, they click yes and it opens the form to add the customer. This is everything I want it to except that when they click yes I want it to open the form to a new record and already have the new customer name populated into the form. So then all they need to do is add the additional details and save the record.

How do I do this? The way it set up now it opens the form to the first record and I am leary that data entry users will write over that first record instead of opening a new record and re-enter the new customer.

Does this make any sense to you? If so please help!! I know it is possible as I have seen databases set up this way, I just am not as expierenced in doing this.

Thanks for the assitance!
 

Answer:auto populate data in a new form

11 more replies
Relevance 49.2%

I found some searches that were in a google search window in Internet Explorer. The only way that I know of getting any searches there is to actually type them there. These searches were of questionable nature. Before I blame others for these searches, I was wondering if there was any way for these entries to get there, such as spyware, etc...

Thanks!
 

Answer:IE Google search and form data

Hi, Malware does some strange things, so I would not put the idea that they could load some search windows totally away... they often install some pretty nasty Favorites links for you, as an example...
Check your Favorites list> all of them, for strange or adult sites. Probably, another user has done the googles...

Would you consider posting a Hijackthis log so we can help spot problems?

Download the file to a folder you previously made just for hijackthis.exe...a permanent folder, created in Program Files folder, for example. Run hijackthis.exe from the folder it is stored in, hit the Scan button and wait a few....when you see the Save Log tab come up, save your log as hijackthis.txt, which opens normally with Notepad.
With the logfile open, hit the Reply button as if you were going to post a Reply to your thread....go to the saved log, at the top, Edit>Select All>Edit>Copy come to the blank reply, click once inside the space, then back at the top of your browser, Edit>Paste and the log should appear as your reply, then submit the reply. Some one will review it and advise.
 

1 more replies
Relevance 49.2%

Hi all. New install of W7 Ult, and fully updated. I use webmail for my Comcast email, and also my personal website email (different address, obviously)

With auto complete on, I open IE11 to my Comcast email, and enter my email address & pwrd. Both are remembered.

I then open the link to my site email, click in the email field, and the email address previously entered at the Comcast site is there.

How do I get rid of that? Clearing the form data and pwrds from Int Options will get rid of the email address & pwrd from the Comcast site, which I do not want to do.

Any ideas? Thanks in advance.

Answer:IE11 form data question

Hi,
Are you using Comcast domain or something with your site :/
Could you post a screen shot of both sign in pages and or a hyperlink to each one so we might see if there is any similarities ?
Cheers.

9 more replies