Computer Support Forum

data entry via data access pages

Question: data entry via data access pages

I have tried creating a data access page several different ways, but am unable to add, edit, or delete my data. I can view it. I've even started from a new database with one table, but am still unable to edit or add data. I've checked the properties of which appear to be fine. Has anyone else had this trouble? I'm using Access 2003.

More replies
Relevance 100%
Preferred Solution: data entry via data access pages

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.)

Relevance 91.02%
Question: ACCESS data entry

I can create a query on my data table and
I'm wondering if it is possible to create a
pop up box that I can put a number in and
have it insert that number on each record
within my query.
This is what I want to do... I have my list
of jurors in a table, each juror has a juror
#, I want to run a query say for jurors #36-
65 and insert them all on panel #3. I want
my table to show Panel #3 beside each jurors'
name without having to enter it 30 times.
Thanks for the help.
 

Answer:ACCESS data entry

6 more replies
Relevance 90.2%

Hi all,

Im having a bit of an issue where I need access to essentially allow 'data entry' on a form to be both yes and no. This is due to a filter in place to display a record with a need to update a certain field.

What's peoples advice on the best way to achieve this?

Im a bit of a simpleton, with no real VBA knowledge (the database is built completely from Macros)

thanks all!
 

More replies
Relevance 89.79%

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 89.38%

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 89.38%

Please, I need urgent help !

I have an access 2000 .MDB file which is complete with forms and reports except for a minor data entry problem.

I have a form say, X based on table X1. The form opens in append mode for data entry with focus on the first field say CTNO.

As soon as the user enters a number; it must locate if the number exists in the underlying table and prompt with a message box.

If the user still wishes, it must allow the rest of the fields to be filled up (that's becos there can be any number of entries based on that CTNO - but a prompt is needed just for sake)

It may sound silly but this is the requirement ! Actually, it would be better if the application can see if it's a new record, than ask the user how many entrie to make and accept as many in a loop for the same CTNO (..a control number)

I am a Foxpro programmer, new to programming in access; but familiar with access for quite some time. And the Ms help is very confusing.

I don't know what is right ! I have tried Dlookup, Findfirst (without reference to DAO), Seek method etc. but to no avail.

Please help me. My boss is demanding. And it will be a big relief if I can get the application running soon !

Thanks a million in advance !
 

Answer:Access 2000 Data Entry Problem !

8 more replies
Relevance 89.38%

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 89.38%

I believe that there is a default value that can be entered in a date field in MS Access that will repeat the date last entered. I can't find it in Help, so ........ help?

I'm building a database to keep track of time (for billing and management purposes). We want to know how much time is spent in various functions and for which clients. So I'll be entering a date next to each job done by each person. There could be dozens of little jobs done in one day and I don't want to re-enter the date each time.

Thanks.
 

Answer:Repeating a date in Access data entry

10 more replies
Relevance 89.38%

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 89.38%

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 89.38%

I have installed a Dymo Label writer and need to print labels from an access database. I can not find any info on how automatically have it generate a label upon entry of the data.
I am using Access 2000.
any help would be greatly appreciated.
Kim
 

Answer:labels that print on entry of data in access

I believe you have to create a report and print that out. If you search the help or this forum, you should get all the information you should need.
 

1 more replies
Relevance 89.38%

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 89.38%

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 88.56%

good day.I have data which I need to create report from it, sample: A B C 1 EXPIRY DATE BALANCE ITEM 2 04/24/12 10,000 RED 3 01/25/12 50,000 BLUE 4 02/26/12 30,000 BLUE 5 03/11/12 10,000 WHITE 6 02/07/12 90,000 GREENSHEET1 -REFERENCE(DATA)JAN FEB MAR APRBLUE BLUE WHITE RED GREENSHEET2 - REPORT TO CREATEAbove are the sample of my reference and the report I should create.I have data that has DATE, BALANCE and ITEM, my boss want a report that summarized all the items that will expire on a monthly basis. Is this possible?Thank you very much!

Answer:Show data in a particuar data entry in excel

Please click on the following line, read the instructions found via that link and then repost your example data. Thanks!Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

12 more replies
Relevance 87.33%

I was losing track of things on my website, so I thought a data base would be very helpful. I've set out to learn Access, but I'm still a beginner and I'm stuck on 3 things so far.

I have set up and related several tables including:
website pages (title, description, date written, etc.) auto number primary key
graphics (file name, size, description) file name primary key
keywords (word, stat1, stat2, stat3) word primary key

I've also set up junction tables since the website pages table has a many to many relationship with both graphics and keywords.

Question 1: How do I make a form that has multiple sub-forms?

I tried to use the wizard to make a data entry form. I wanted a form with multiple sub-forms.
If I enter the fields from 2 tables, I can easily make a form with a sub-form. If I enter fields from all 3 tables, the wizard acts completely differently and I can't figure out how to do sub-forms.

Question 2: How can I make a combo box that will cover multiple fields at once?

I fill the graphics table as I make the graphics. I wanted to use a combo box so I could choose an existing graphic OR add a new one. The combo box works fine for the file name.
The problem:
I want it to auto fill the size and description if I choose an existing file name OR allow me to enter size & description if I enter a new file name.

Question 3: How can I handle many to many relationships between records within one table?

I want to track links from each page to ... Read more

Answer:Solved: Access 2003 Data Entry Forms - beginner needs help please

16 more replies
Relevance 87.33%

I have a database with approximately 15 tables and forms. There is a form created for every table. When a form is updated, I want the other forms with the same fields to also automatically update without having to re-enter the information in a different form. Is this possible? Please advise.

Thanks,
Tonya
 

Answer:Solved: Access 2007: Forms for Data Entry-Update

8 more replies
Relevance 86.51%

I have a database with a linked subform that was allowing multiple users enter data yesterday. As far as I can tell there have not been any changes because most users do not have the priveledges to edit the forms. What could have happened?
 

Answer:Access 2007 linked subform is no longer allowing data entry

14 more replies
Relevance 85.69%
Question: Data access pages

I want to upload a small searchable database facility to my website using access 2003. I understand data access page is the way to do this. I cannot get it to work however. When preparing the data access page a dialogue box says my link addresses are absolute and not relative. How do I change the links?Any advice greatfully received

Answer:Data access pages

Type "data access page"into the search facility within the microsoft knowlege base as MS support click here

2 more replies
Relevance 84.46%

Our school uses data access pages to front a booking system for ICT classrooms. With our win 95, 98 and 2000 machines we can see the html page and the system works fine. However with our new xp machines the page will not display. Is anyone aware of a problem with windows xp/IE6 clashing with data access pages produced in access 2000?

Answer:Problem with data access pages and win XP/IE6

Sorry to bump but we're pretty desperate to resolve this!

1 more replies
Relevance 83.64%

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 83.64%

Does anybody know if Data Access Pages can be used over a network? I've made several pages and have tried putting them on a network drive and the data is not updated from computer to computer, it is only updated on the computer that you save it on. Now if I put something into the database directly that will be viewable on every computer. Any help is greatly appreciated.
 

Answer:Question about Microsoft Data Access Pages

Avoid DAP like the plague. They are the worst thing MS put into Access. If you want to do it right, use ASP or ASP.NET and host it on small web server (could even be your workstation [Win2000 pro/XP pro] : limited to 10 users though. A full windows server version is unlimted access).
 

7 more replies
Relevance 82.41%

I don't know a lot about Access, but have a pretty good, if very dated, knowledge of SQL from many years ago (pre-Windows timeframe). So, I know what I want to do with my database, and I'm quite confident it can be done, but doing it from within Access is a little challenging for me. Anyway, I've developed several tables from which I want to generate some data access pages, but when I've tried to do that I get an error message telling me that ActiveX is prohibited because of my settings and so it cannot be done.

I assume that this is the same ActiveX which I disabled for computer protection. I've noticed in playing around with Access that there are various ActiveX controls that it seems one can individually activate. I don't have a clue what any of them do, so have left them alone. Are there some, which if activated, would allow me to make my access pages, but would also leave my computer protection, such as it is, in place, or do I simply need to reactivate the whole of ActiveX?
 

Answer:Access & Data Access Pages & ActiveX

When you get the error message have you tried the "Help" button on the message to see if it explains which ActiveX control is the problem?
There is an ActiveX control button on the Main Menu under "Tools" you could have a look at that.
 

3 more replies
Relevance 81.18%

I am looking to enter data into Column A and have the time (hh:mm:ss) at which the entry was made automatically generate in the neighbouring cell in Column B. In a response to a similar question, someone suggested using a simple data entry program that stores the time upon entry but failed to give an example of what a simple program might be. I was previously entering data on a hand held Psion which is the same idea, but I no longer have access to a psion and am now using Excel 2008 for Mac. I would like to use a similar type of program instead of trying to figure out excel, so if anyone has any suggestions I would love to hear them.In terms of excel, much of the information I am coming across in forums is in regards to a start, end and duration time, whereas I am trying to determine a rate of behaviors per second, so I have a number of data points to enter which require a corresponding time recorded to the nearest second, thus start/stop/duration aren't the main concern.Can anyone tell me a way to do this in excel or a data entry program that will allow me to enter my data & automatically note the time at which a data point was entered into a given cell?

Answer:Data entry program stores time upon entry?

If you were using Excel on Windows, we could suggest a very simple "program" written in VBA that would monitor Column A and place the current system time next to the cell that was changed.Unfortunately, VBA was removed in Excel 2008 for MAC.Fortunately, it is supposedly coming back in Excel 2011 for MAC.After you upgrade, come on back and we'll help you out. ;-)I understand that Apple Script can be used in place of VBA, but I don't know how to code in Apple Script.Maybe a MAC forum would be a good place to ask your question.

6 more replies
Relevance 78.72%

Hello,

I have two problems:

1.
I have a lot of scanning data, all date and time stamped. All the scans show different status of shipped packages (all shipments have unique ID#, but there are multiple scans on route for all of them to track the packages). I want to find all the packages, for which there was "misdirected" scan, then for all of them, show the scan before. So, the end result would be all the scans that show for each package where it was misdirected (the terminal# of the scan before the misdirect scan).

2.
I want to automate this: run 5 queries every two hours between 8am and 10pm, copy and paste all results into Excel to specified areas (e.g. first query results to A1, second to A5000, third to A10000, etc. or onto different tabs), save as .csv to a specific folder, then send it as attachment to a given e-mail address. Even partial solution can be good.
I only know macros (somewhat), not as much VBA, so I tried that with the TransferSpreadsheet command, but can't get it work.

Any help is greatly appreciated.
 

Answer:Solved: ACCESS: Show second latest data and export data to excel from macro

14 more replies
Relevance 78.72%

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 78.72%

I am an absolute begineer in MS Access. Will try to put my question as simply n clearly as possible.

I have designed a database to keep history of our company's projects. The 'Master Project History Table' contains fields including 'Project Ref', 'Project Title', 'Project Budget' and 'Project Year'. The users are expected to populate the table through 'Master Project HistoryForm'.

The key field is set as 'Project Ref'.

Some of the projects are combined with each other and to display this info, 'Master Project History Form' also has the fields 'Project Ref-1', 'Project Title-1', 'Project Budget-1' and 'Project Year-1'.

I am loking for a code for the ('On Update' event) that will fetch and display data in 'Project Title-1', 'Project Budget-1' and 'Project Year-1' fields when 'Project Ref-1' is updated. Please note that all this info is coming from the same 'Master Project History Table'.

My IT guys told me to use a code with variable for each field that goes something like this (to update Project Title-1 field):

Dim varX As Variant

varX = DLookup("[Project Title]" , "Master Project History Table" , "[Project Ref]=" & Forms![Master Project History Form]![Project Ref-1])

Me![Project Title-1] = varX

And then repeat for each other field by defining new vari... Read more

Answer:MS Access: Updating Data In One Field Should Update Data In All Relevant Fields

14 more replies
Relevance 78.31%

Basically I have a situation where users are creating data tables in Microsoft Word using the creating table functionality, and are then resquesting that the data will be imported into a single Microsoft Database field.

Please could someone show me the best way of doing this!!!!!!

Cheers !!!
 

Answer:Importing Table Data Into Multiple Access Field Data?

Do you mean they're creating, say, a 3-row by 3-column table and then they want to import everything in that one table into a single field? a single record?

Out of curiosity, what happens if you copy and paste, perhaps with an intermediate step through Excel?

Also, is there a reason why your users cannot work directly in Access?

More details, please.
 

3 more replies
Relevance 76.26%

hey

i need data off an old pc which was windows 98 word97
so i put it in my comp (xp. office suite 8) i want to access files from old harddrive but wheni click word it says data might be currupt? plz help
 

Answer:old harddrive. need data off it. put as slave. cant access data

iLLegaL89 said:

hey

i need data off an old pc which was windows 98 word97
so i put it in my comp (xp. office suite 8) i want to access files from old harddrive but wheni click word it says data might be currupt? plz helpClick to expand...

Well, generally all the office suits are backward compatible...so there's should not be any problem. Can you open that word file(s) on the old PC (World 97 as u mentioned?) If it is so, you might have some problem with this new PC office suit.
Try, making copy of the old files in old PC using save as or may be you can convert doc files (if you don't have some hi level formating) to rtf files. That can be opened in Wordpad comes with every Windows OS.
This might help, i guess..
- Nirav
 

3 more replies
Relevance 76.26%

Is this possible? I have a simple Access database. One of the data fields is the name. It is entered as Last, First in the box. Is there a way to split this data to make it easier to search the database? Here's a pic of the database.
And manually creating a new field will be impractical as there are 25,000+ records in this dataabse. Unless this can be split somehow and the new field created then.

More replies
Relevance 74.21%
Question: data entry

I have a collection of about 10 forms in Microsoft Word. Many of these forms require data that is the same on every form. Is there a way for me to only have to type the information once and have it pre-filll all ten forms with the same data? (Kind of like you can do with excel.)
 

More replies
Relevance 74.21%
Question: Data Entry

I failed to read the Forum Rules.
 

Answer:Data Entry

Here they are >>> Forum Rules
Thread closed, account disabled.
 

1 more replies
Relevance 74.21%
Question: data entry

hi all

i have set up a worksheet, on it are 6 checkboxes that correspond to hidden rows on the worksheet, i.e
checkbox1 when checked allows row 20 to be visible, checkbox2 allows row 21 to be visible etc, when a row is visible, text data needs to be entered in column j of that row, once it is entered the user would then press the continue button to carry on, what i want code to be able to do is check that data has been entered in the visible cell, if not a error message to appear asking the user to enter data, before continuing.

this needs to happen only when the row is visible

the checkboxes when checked show the rows in order i.e
checkbox1 shows row 20
checkbox2 show rows 20, 21
checkbox3 shows rows 20, 21, 22 etc

any help appreciated
 

Answer:data entry

Add code to your 'continue' button which looks at the state of the checkbox. You'll need to know which ranges correspond to which checkboxes, and check the ranges accordingly. Make sense? Either hard-code the checkboxes or loop through your controls and specify which checkboxes to check. Let us know if you need more help.
 

3 more replies
Relevance 73.8%

My data card supports EDGE and 3G data. I'm getting GPRS data speed though from system configuration, this is not possible as When any phone or modem supports EDGE then it will not go for GPRS. can anybody tell me whether my data card is showing appropriate data technology or not?

More replies
Relevance 73.39%

Whenever I open up browser or program with data entry place then 66666666 is auto entered - Got McAfee run full scan still not fixed

Answer:why 666 on data entry places

Update & Run Malwarebytes' Anti-Malware ( MBAM ) Free Version. Use Quick scan ( now called Threat Scan ) Malwarebytes' Anti-Malwarehttp://www.softpedia.com/get/Antivi...http://www.malwarebytes.org/free/ Make sure you uncheck > Enable free trial < at the END of the install.http://i.imgur.com/tUFCbYz.gifClick the Settings tab at the top, and then in the left column, select Detections and Protections, and if not already checked place a checkmark in the selection box to Scan for rootkits.http://i.imgur.com/dZgt1g2.gifCopy and Paste the contents of the log, in your reply please.Log locationshttp://i.imgur.com/s05hsP9.gifhttp://i.imgur.com/qZ5dybV.gifhttp://i.imgur.com/wOHlluy.gifhttp://i.imgur.com/pYQQLah.gifIf potential threats are detected, ensure that Quarantine is selected as the Action for all the listed items, and click the Apply Actions button.If your MBAM log indicates "No action taken". That's usually a result of NOT clicking the Apply Actions button after the scan. In most cases, a restart will be required.

5 more replies
Relevance 73.39%

HiI have build a user form via vba in excel 2007 using instructions mentioned in the sitehttp://www.contextures.com/xlUserFo...Nw i want to incorporate a search item that is when i enter a part number first it search in existing data if found display another user form to enter missing informationotherwise enter the dataIs it possible if yes cn any1 plz illustrate.Thanks in advance

Answer:Data Entry Search Via Vba

The Excel 2010 Help files left out this example, but it can be found in Excel 2003 and earlier.It's a shame that 2007 and later do not include this powerful example of how to use .Find in VBA.Replace the instructions within the Do-Loop with the instructions that you need.Example
This example finds all cells in the range A1:A500 on worksheet one
that contain the value 2 and changes it to 5.

With Worksheets(1).Range("a1:a500")
Set c = .Find(2, lookin:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Value = 5
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 73.39%

I have constructed a large spreadsheet file which I use, it is extremely complex but works well. I record the details about a lot of other files and include in one column the date when each one is updated.Is there any way of asking Excel to compare the entry date with today's date and to let me know that (for example) one years has passed, or six months since it was updated?Thanks

Answer:Entry data in Excel

It depends on how you want it to let you know.For example you could add another column (if you make sure the analysis toolpak is loaded) which does this:=IF(EDATE(A1,6)<=TODAY(),"6MTH WARNING","")Then alongside each file which hasn't been updated for 6 months will have the warning alongside. If you want Excel to hunt these down and warn you you probably want some VBA/A Macro which is also possible. Let us know exactly what you want it to do.

6 more replies
Relevance 73.39%
Question: Excel Data Entry

I would like to enter a large number of  nine to seventeen digit numbers that I have copied from a website into an Excel spreadsheet. They are currently separated by commas. I would like to have each number in a separate cell. How would I accomplish this? A PDF document with the numbers is attached

Answer:Excel Data Entry

Large document.Here is part of it:3","100000857240769-0","746858137-3","746858137-0","100002102230952-0","100002102230952-3","100000118202437-3","100000118202437-0","100000748429788-3","100000748429788-0","1699007105-3","1699007105-0","1487529605-0","1487529605-It does not seem to be a standard number format. What does the dash (-) mean? In regular expression it would mean subtraction.  Is that right?If all the dashes could be converted to periods (.) then excel could read it as a list of numbers.But as it is, it can only be a string, not a number And the end of line char is in the wrong place.You can export the PDF as a plain text file and then the spreadsheet program, Excel, can  read into a spreadsheet. Bu the dash char is going to give unexpected results.This might help.Import or export text (.txt or .csv) filesThat is the best I can do. 

6 more replies
Relevance 73.39%

I am designing a database that will accept data from a web form. The end users are clinical staff who will see patients, collect info, and fill out the form. To save them from completing a paper form in the office and then entering the data later (not all of the offices will have desktop computers), one of the doctors suggested tablet PCs.

I've never worked with tablet PCs before, but Wikipedia makes them sound like Palms, which I *do* have experience with. For those of you with experience, do you care to weigh in on the technical merits of a tablet PC? I want to accomodate end users that may not have a great deal of technical experience -- I don't want to do a lot of tech support. Thoughts?

Thanks,
Lisa
 

More replies
Relevance 73.39%

Hi people,

I currently use the following code to track job status. Due to the size of the tracker, I keep columns B and C hidden so it's legible when I print. Unfortunately this can mean that columns B and C get overlooked when I new job is set up. Would it be possible to force data entry into cells B and C if there is an entry into A?

I had a lot of help from this forum with the VBA below. I still consider myself a novice when it comes to this..!

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

Dim Cell As Range
Dim CI As Long
Dim N As Long
Dim R As Long
Dim Rng As Range
Dim RngEnd As Range
Dim Status As String
Dim X As Long

On Error GoTo ResetEvents
Application.EnableEvents = False ' This stops the on_change trigger until it's ready
' has to be rest at the end of the code (see below)
If Target.Cells.Count > 1 Then GoTo netd

Application.ScreenUpdating = False

If Target.Column = 10 Then
If Target.Value <> "" Then
If Target.Value = "9. Completed" Then
Completed oRow:=Target.Row
Else
Cells(Target.Row, "L").Value = Date
End If
Else
Cells(Target.Row, "L").ClearContents
End If
End If

If Target.Column = 10 Then
If Target.Value <> "" Then
If Target.Value = "10. Rejected" Then
Rejected oRow:=Target.Row
Else
Cells(Target.Row, "L").Value = Date
End If
Else
Cells(Target.Row, "N").ClearContents
End If
End If

For Each Rng In Range("A2:A"... Read more

Answer:How to force data entry with VBA

16 more replies
Relevance 73.39%

Hey, I'm the IT guy for Family Resource Agency and I'm running into a problem. I'm constantly replacing keyboards for our Data Entry people. I was just wondering if there is a keyboard specifically designed for people punching numbers all day that might last more than a couple of months. Most of the more expensive keyboards I've looked at have the price tag because of their features. I just want a strong durable office keyboard. I haven't had too much luck finding one.

Answer:Data Entry Keyboard

Welcome to tech forums.

What keyboard are you currently using for data-entry? And how are they wearing out? Key's stop functioning, or what?

Looking at NewEgg, I can across the Logitech 967738-0403 Black 104 Normal Keys USB Standard Deluxe 250 Keyboard. It has a 3 year limited warranty on parts.
Newegg.com - Logitech 967738-0403 Black 104 Normal Keys USB Standard Deluxe 250 Keyboard - OEM

I've seen bulk keyboards on NewEgg, but not today.

8 more replies
Relevance 73.39%

Hi all

I use windows XP, Excel 2003.

I am creating an excel form for clients to fill in for my business, and I want to ensure that the fields I need information for are never left blank. I have already used data validation to control what gets entered in the cells, but the 'ignore blank' tick box doesn't really seem to do much. If I tab through the fields (I have protected everything apart from the 5 cells I want data in) then the 'ignore blank' feature unticked seems to force data entry if I try and enter something in there and then backspace it. But if I just don't enter anything, or do but later hit the delete button, I can end up with blank cells.

How do I ensure that these cells do have data entered, and that it will always have data entered up until it's saved?
 

Answer:How to force data entry

Can you please tell me how you have setup data validation? I am referring to what you put in there as the criteria.
 

2 more replies
Relevance 73.39%

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 72.57%

Hello,

Is it possible to keep track of data entries in Excel?

I have daily report log that I need to maintain between several users. I have 'completed' and 'pending' column as well as 'date' column

What I am trying to achieve?

I am hoping to create an 'OVERVIEW' sheet where:
- I can display number of 'completed' task (I have managed to achieved this)
- Display number of 'pending' task (managed to achieved this)
- Display number of newest entries, (perhaps identified by the latest 'date') -is there any formula to do this?

Thank you for your kind help. Much obliged.
 

Answer:Is it possible to keep track data entry in Excel

7 more replies
Relevance 72.57%

Hi,

I am using Outloook 2010 and recently I have installed Business Contact Manager 2010. I have entered all my customer data and now I discovered that I made a some big mistakes:

I have modified the Business Contact form and filled the Company details in there and also the contacts belonging to the company. As a result of the modification I have many new fields (which is not a problem) and lost some important fields including email, address (i have replaced these for new fields that I created myself).

Of course, I should have kept the important fields such as address and email, etc. and I should have created an account for each company and fill in the details in the Account form. Then create a business contact and fill in the contact details in the Business Contact form and add these to the accounts.

I want to open each Business Contact Form and copy and paste the company details into a new created account via the Account form. Then I want to create a new business contact WITH THE STANDARD BUSINESS CONTACT FORM and copy paste the contact details from the MODIFIED BUSINESS CONTACT FORM into it.

My problem is: how can I have the standard business contact form and the modified business contact form at the same time? I could reset the modified form to get the standard form but then I lose the contact details before I pasted them into the standard form..

I hope someone knows a solution as I spent 60+ hours on this already.

I have attached a screenshot of the modifie... Read more

Answer:BCM 2010 data entry challenge

There is a wealth of information on using Business Contact Manager in the following link:
Business Contact Manager for Outlook 2010 - Outlook - Office.com

I hope you find an answer there.

3 more replies
Relevance 72.57%

For the last week or two, my computer has slowed down drastically when I am entering search data on Amazon, newegg, ebay, and other sites. I have to type one letter at a time and wait a few seconds for the next letter to enter.

I have all kinds of security, spyware, and anti-virus software installed and think it might be my modem, I bought a new Motorola modem which did not help. Cox Cable told my that my previous modem was very old which is true.

I am using Internet Explorer 8 on Windows 7 Professional. All other typing on the computer is OK and will accept data as quickly as I can enter it.

Any ideas on what might be causing this?

Thanks
 

Answer:Solved: Slow data entry

8 more replies
Relevance 72.57%

When using the excel spreadsheet and entering numbers and letters, it pauses for almost a minute when I click from box to box. What could prossibly be the problem of data entry on excel having a pause when tryin to enter information?

Answer:Excel data entry pauses

I don't know what would cause this - but would suggest uninstalling the Microsoft Office programs and then reinstalling them.

1 more replies
Relevance 72.57%

When I am using any browser (also when filling in this enquiry) - the blue bar along the top of the Windows frame turns to gray and I lose the ability to enter text for a few seconds

The bar reverts to blue and then I can continue typing

Any suggestions as to the cause ??

I have run anti-virus and anti-malware scans both report no problems

Appreciate any/all assistance and advice to help me

Thanks
 

Answer:Data entry problems in Windows

That's a very odd issue. Have you tried doing a system restore (http://windows.microsoft.com/en-US/windows7/products/features/system-restore) to a point before this started happening to see if there are any positive results?

-- Ryan
Windows Outreach Team
 

1 more replies
Relevance 72.57%

I am familiar with the standard Data Validation within Excel but wondered if there was a way of using conditional validation? i.e. if the entry in column x changes then Data Validation for column y changes to a different set of options?

Answer:Excel Data Entry Validation

i would think the 'if' function would do this for you and you can specify results or cell colour.johnny.

3 more replies
Relevance 72.57%

on a worksheet i have, i am entering numbers into one cell(a1), cell a2 is a running total of all entries made in a1, this works well enough, is there anyway by using code or formulas that i can also have keep a note of each of the entries made in cell c1, i.e if entries made in a1 are 5,7,11,15, giving a total of 38 in a2, i would like the 4 seperate numbers to be shown elsewhere on the worksheet
 

Answer:Solved: data entry excel

10 more replies
Relevance 72.57%

I use Win XP, Excel 2002 and have just encountered an issue I cannot solve. When working with cells formatted for either numbers or currency, entry of a number shows an extra 12 places to the left of the decimal when no decimal is entered (123 becomes 1230000000000). If a decimal is entered (123.), the number displays and functions properly. When I change the format of the cells involved to text, the following is displayed when a whole number (123) is entered: 1.23E+12 I have opened new files without modifying the format at all and this is still occurring. What is going on??
 

More replies
Relevance 72.57%

Hello Tom!I would like to know if there is a macro for preventing employees from retroactively feeding data into cells, by mistake or intentionally, if so- how do I make it Happen?Your's Truely,Eyal

Answer:Macro To Prevent Data Entry?

This process will allow the user to enter data in Column A just once:1 - Select Column A2 - Click Format...Cells...Protection Tab3 - Uncheck the Locked option4 - Click Tools...Protection...Protect Sheet5 - Set Password to the word secret6 - Click the Sheet tab for the sheet and paste this code into the window that opens:Private Sub Worksheet_Change(ByVal Target As Range)
'Determine if change was to Column A
If Target.Column = 1 Then
'If yes, Unprotect sheet
Sheets("Sheet1").Unprotect Password:="secret"
'Locked changed cell
Target.Locked = True
'Protect Sheet
Sheets("Sheet1").Protect Password:="secret"
End If
End Sub
When the user enters data in Column A, the code will Unprotect the sheet, Lock the cell that was changed and Protect the sheet again.You should also Hide and Password Protect the code so that the user can't see/changed it.If you need to know how to do that, let us know.

6 more replies
Relevance 72.57%

Hi,
I have a database in Access 2010 with a field for FirstName and a field for Surname. I have one user who keeps entering both the first and surname in the first name field and leaving the surname blank. So I can stop this I was wondering if its possible to not allow spaces in the data entry of the FirstName field. If they need to enter a first name that is actually two e.g. Carol Anne they can hyphenate it!

All suggestions gratefully accepted.
Thanks
Karen
 

Answer:Not allowing spaces in data entry

8 more replies
Relevance 72.57%

Hi,
I want to lock a range of cell ( Column) after data entry. Cell should lock automatically.

for example if D5= today(), then range of cell from D5 to D45 is ediatble otherwise cell should be blocked.

No body can touch cell for yesterday or tomorrow...

cell should be open only for the date...
 

Answer:Lock cells after data entry

What program is involved?

{redoak}
 

2 more replies
Relevance 72.57%

Please help.

I'm am on Excel, and in my first column designated as "DATE" 50% of the time when I input a date it will display it in the cell but now it is converting it to a row of #symbols and the input looks like this...

######

this happens no matter what dat I put in now. I have gone up to Format, cell and it tells me it is set to display DATE but I'm only getting: ######
And now it is doing it randomly in my Dollar amount column too.
Please Advise,

Thank you so much
 

Answer:EXCEL Data Entry Problem

7 more replies
Relevance 72.57%

Hey,

I have made a worksheet and I have this cell range A to S. Now I want that used must put data in cell range A to R. Can anyone help?

Thank you
 

Answer:Excel Force Data Entry

With thanks to Zack Barresse: try this link: http://www.vbaexpress.com/kb/getarticle.php?kb_id=364

P.S. At ALL time please mention your Excel version!
 

1 more replies
Relevance 71.75%

Hello, I have a form/subform data entry question.

When a name and date is entered into my Main form, any existing records for that name/date combination are displayed in the subform. If the data entry operator wants to add additional records for that name/date combination, depending on the number of existing subform records, he may have to scroll to the last subform entry in order to view a blank new record. How can I get the subform to display a blank record at the top to eliminate the need to scroll?

Thank you for your help.
 

Answer:Solved: AC2007 - SubForm Data Entry

Unfortunately as far as I know you can't.
What you can do is add a Command button that takes the user to a new record, the command button Wizard will create this for you.
 

2 more replies
Relevance 71.75%

How come when I copy and paste text into a spreadsheet cell using the Works spreadsheet/Office Excel programs, it spreads the information to more than just the one intended cell automatically?How can I prevent this from happening?

Answer:Microsoft spreadsheet cell data entry

Because sometimes Excel thinks it knows what's best for you.Excel tries to help you by remembering the settings from the last time you used Data...Text to Columns.Sometimes it will split the pasted data into columns because the last time you used that function you had it set for Delimited...Space.You could try using ALT E S V.Check out this list of pasting tips then scroll down to the bottom of the comments and read what Sam had to say on May 12, 2010.

4 more replies
Relevance 71.75%

I have a strange problem with my excel program. just recently i cannot type the letters c u t h in any cell.What could be causing this?Thank youTony

Answer:Excel 2007 Won't Accept Data Entry

What does i cannot type mean?Nothing shows up, you get an error, the wrong characters appear, something else?

4 more replies
Relevance 71.75%

I am converting from ACT! 6.0 to Outlook 2003. I have converted all of the contact files and Outlook seemed to be behaving. When I went to enter data for a new contact, however, five of the Outlook fields would not let me enter data: "Business Address Street"; "Home Address Street"; "Email"; Email 2"; and "Email 3." There seems to be a trend here but I cannot find any info at Microsoft for this type of problem. Any ideas?

More replies
Relevance 71.75%

Hi,pl. send me a VB Program for using in M.S Excel for :if the one condition of a cell (Say A1) is "F" then the cell (say B1) will disappear and nothing could be written there, otherwise if cell A1 is "T" then DATE can be written and displayed in cell B1.

Answer:Need VBA To Clear Cell, Prevent Data Entry

A posting suggestion:When you post in a help forum such as this one, please try to use a Subject Line that gives us an idea of what your question is about.If everyone used a subject line such as VB Program or Excel Help, we wouldn't be able to tell one question from another. In addition, it makes searching the archives for answers a lot harder.I have edited the subject line for this thread.Thanks!DerbyDad03Office Forum Moderator

3 more replies
Relevance 71.75%

Hi, Was creating a workbook today comprising of 2 sheets. first sheet contains vlookups and the other 'sheet2' my data. Unfortunately I have to much data for the form option to work. Is there another option I can use rather than tab to each cell. Using excel 2003. Basically when I created my database I was entering additional columns so that my vlookup formula could populate rows, e.g. I have 6 sections(columns) each containing 10 rows which are populated with a vlookup formula in each, works out at 60 columns of data. After inserting column number 30 I think, excel stated it couldn't perform 'form option' - too much data. The form option was very good because I just clicked a cell and it gave me the option of entering data quickly rather than navigating through a large data sheet.Many thanks.

More replies
Relevance 71.75%

I have found that I am running out of space on one of my HD's and found that data entry of docs, spreadsheets, emails etc is being copied automatically onto it as well the second disk which is where I want it to be. I have tried to start deleting the offending folders but I get the message "Cannot delete-access is denied. Make sure the disk is not full, or write protected or the file is not currently in use"Where do I look in the system to alter this what appears to be an automated backup?Thanks in advance

Answer:Twin disks with data entry duplicated on both

Sounds like you have a RAID1 system in operation, BernardG.

3 more replies
Relevance 71.75%

I am using XP Home Edition on a compaq. I access MSN hotmail through Internet Explorer. My pc has an AMD Athlon 64 3000+ Processor and 60 GB hard drive (almost half is still free).

Sometimes (not always), when I try to enter data into a form online, when I press <enter>, the form I am working on is deleted, all files close and I get an error message that says the error is a problem with MSN. There is a link to fix the problem. When I click on that, I am asked for my user name and password. No matter what name I use, the system won't recognize my account. I am then directed to create a new account or buy the upgraded MSN. I have to reboot to get back into hotmail, which is the platform from which I do my browsing.

I've been trying to set up a blog in blogger.com and this happens every time I try to edit the layout. I set up my blog through my hotmail account, and then tried through my gmail account. The problem keeps happening.

I tried cleaning the pc (AVG, Ad-aware, CCleaner, Advanced Windows Care, and other programs; registry cleaner programs; defragment programs) with no change. I tried resetting to the earliest system restore point I could (Feb 2008) and then downloaded all available MSN patches, including .net framework 3.0 and it's service pack. I still have the problem.

In case there were MSN patches I missed, I tried using MSBN (?), but it doesn't work for XP Home.

Any suggestions?

I am a first time poster but ... Read more

Answer:MSN error message and data entry problem

Hi Philosophical Cat,
Nice to have a lurker become a poster.

Do the forms you are trying to fill out have to do with a service which requires payment?

abri
 

5 more replies
Relevance 71.75%

Hey everyone,
Have not been here for awhile ( that's good). Well I recently been away from my PC while its logged on and been hearing mouse clicks ( lots of them). Actually while I am typing this, I just heard three clicks in succession. There it goes ( another one). I ran a Malwarebytes scan and it picked up ( again) that I have a file in my regestry called "Hijack System". Whay I say " again" cause this is not the first time that I have run Malware bytes , found and cleaned the problem BUT it comes back OR was never removed. I did a scan earlier in the month , found it to be clean and still was getting the mouse clicks.
How do I proceed to perminently remove and RESTRAIN from re-entering this spyware? Norton did not pick it up and in the past ( last year) Mc Afee Total Protection did not pick it up either

Answer:Hijack System Registry Data entry

Scanning over your other threads I couldn't find one log postedPost the MBAM logs showing this current infectionOtherwise we are operating blind

1 more replies
Relevance 71.75%

I have been working on this issue for a few months . I have updated the every thing I can think of remove old files still having an issue at Random time the PC would get glitch and BSOD . I have several dump files Here the PC spec Dell optiplex 3010 window 7 pro 64 bit 4GB

Answer:BSOD random time while doing data entry

Allot of important info is missing from your zip, please follow Blue Screen of Death (BSOD) Posting Instructions to grab all and upload a new report here.

4 more replies
Relevance 71.75%

hi all

i nave a userfom that is activated from a button on sheet1, a listbox is shown for the user to make a selection, this then is shown in cell p3 on sheet2, the problem is if i lock the cell and then protect sheet2, an error keeps appearing, i need the sheet protected and there are 2 cells that are unlocked for data entry, but i need cell p3 to be protected.
 

Answer:Solved: cell locked/data entry

If the cells does not need to be unlocked for use, then all you need is to Unprotect and Protect the sheet in your button code

Button is pressed

If listbox value <>"" then
sheets("Sheet2").Unprotect
Sheets("Sheet2").Range("P3") = lisbox value
sheets("Sheet2").Protect

If the sheet is protected with a password you can add the passwrod to the lines

sheets("Sheet2").Unprotect Password:="your password as text"

sheets("Sheet2").Protect Password:="your password as text"

If you need some help, just holler
 

2 more replies
Relevance 71.75%

Hello. Thanks in advance for any help that this forum can provide in solving this problem.

I have a form in access based on tblSubmissionTracker that has some comboboxs that allow a user to select predefined values for records to be updated to tblSubmissionTracker. This all works good.

The fields in tblSubmissionTracker are Country, Sector, Business, Report_Date, Submitted.

Inside the form, I have a subform, subfrmContactDisplay, that is based on tblContacts. subfrmContactDisplay is set to display the following fields from tblContacts: Country, Sector, Primary Contact, E-mail, and some others.

What I want to happen is each time a user enters a selection for country, business in the main form the subform shows the corresponding tblContact record for that country sector combination (each business is linked to a sector, and the sector populates in the main form via a list box linked to a query, which uses the business selected in the main form as a parameter). I also want to be able to edit fields in that record, should they need editing.

I've placed code on the change event of the business combobox to requery the sector list box and then requery the subform.

Through the process of building this I haven't been able to get it to work properly. I've tried playing with many of the options, but to no avail. Sometimes I get some parts working, other times, I don't. Right now, I have the mainform set to data entry and all edit options checked to yes (add, de... Read more

Answer:Solved: Data Entry Form with SubForm

It sounds like you may be over complicating it.
First of all if you set the mainform to Data Entry = yes it means you can only enter new records in it.
Second you should not need to requery the Subform if the Master/Child links are working correctly.
Can you post a zipped Access 2000-2003 version on here with some simple dummy data.
Or at least post a Screen Print of the Table Relationships and the Forms in design view.
 

2 more replies
Relevance 70.93%

Hi,

I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

So that the excel size won't be that big and also it saves processing time.
 

Answer:Solved: Access data export into Excel as the data linked to excel.

16 more replies
Relevance 70.93%

I have a table with several simple formulae in it, that sum data across a row.Currently, I use the "Copy Down" function, but that produces several rows of zeros in the various columns where there is no data to compute.Is there a way of entering data in, say column 1, that will invoke the formulae onto the current line, so I can have an aesthetic spreadsheet that expands as I enter data?I tried to add a JPG that explains visually what I want, but the system wouldn't accept it. Sorrymessage edited by happywanderer

Answer:Excel - automatic copy formulae on data entry

You could wrap your sum formula in an IF() statement so if a cell is blank, the sum formula does not calculate.Something like:=IF(A1="","",SUM(A1*B1))There is even an Excel Function, called ISBLANK()=IF(ISBLANK(A1),"",F1/G1)MIKEhttp://www.skeptic.com/

3 more replies
Relevance 70.93%

Hi, Can anyone help?????I need vba for cmdbutton on userform to move one row data into another row.I have a worksheet "details1" Column A: Column B: Column C: Zone Container ID Client Name1 1LB 108 Roger2 1LF 3 1UB 4 1UF I also have another worksheet "warehouse1" which has cmdbuttons on. clicking on one will show userform populated with data from "details1" ie...click cmdbutton 1LB brings up userform with all "A1" dataon this userform is cmdbutton to open new userform called "move"this userform opens up and has a textbox which is populated with the container ID which is in that zone. Below that textbox is another textbox which the user will enter in a "zone" for which they to move that container to.Foe example... if user wants to move container "108" to zone "1UF" they will type into the textbox 1UF and press cmdbutton on form "move&save". This will move all row data from "A1" INTO ROW "A4"I am really struggling for the code for the "move&save" button, to move the data. Have tried copying others and changing slightly but nothing working.Can anyone please help???
 

Answer:userform select row by textbox entry and move data to specified row

sorry, didnt realize the text i wrote wouldnt be formated. my question makes no sense as it is. i will try to post it another way.
 

2 more replies
Relevance 70.93%

At work, our computer does not have Access, but it has Excel. I am creating a database of clients in Excel. Is there any way to enter contents into a cell, hit Tab button, and automatically move to the next cell to the right and at the end of the row, automatically Tab to the first cell in the next row(entering the next record, client)?
Thanks,
Fred
 

Answer:Auto Tabbing in Excel Worksheet Data Entry

Hey Fred,

Try this. When you enter data in a cell use TAB to go to the next cell and continue along using Tab until you need to go back to the first column. When you get to the last cell in that row, enter your data and then hit ENTER.

This then returns to the next row in the first column.

Hope that helps
B
 

3 more replies
Relevance 70.93%

i have all the latest versions of excell and windows. I need to know how to require data entry in a cell without allowing to go to next cell without entering data, for multiple cells. I already did data validation, locked all other cells. and how to i make it so i can choose which cell it starts at and goes to next?
 

Answer:how do i force data entry before allowing to move to next cell

16 more replies
Relevance 70.93%

I've searched the database for relevent posts, but could not find anything that even touched on my immediate concern...I'm not sure what info y'all need to assist me, so i'll explain what happens as brief as i can.

I logon to the Internet (Netscape - my Firefox began acting up so i switched) and my browser boots my tabs (a few forums and my Inbox email)...I have several things in my system tray (avast!, AV97 Audio, InCD, nVidia, Telus Security[AV disabled - i use Avast!)

I access one of my forums (click! - right here; just now my cursor went off page while i was typing this) and begin postings....

Now; shortly after i logon; (like just a few moments ago) a window opens and closes very very very fast in the upper left corner of my browser...there is no time to read it or to examine anything it is about - I think this is the thing that is causing my problem, but i'm not sure.

Shortly after this flicker of a small window opening in the upper left corner of my browser, probably within about 3-5 minutes, this concern about my active cursor begins to happen....it's random....sometimes it goes away every 10-30 seconds.....sometimes it remains active (click! just happened again!! - The notice of the click! is me having to click the cursor back into my active page; this one for instance) I type at about 35-45 words per minute....so it's happening way too often for my liking.

Does anyone here know/suppose/conject what may be happening? Is there a way to discover what that window... Read more

More replies
Relevance 70.93%

I am working with Lotus Symphony 1.3.0 and after entering data in a cell pointer moves down how do you stop this so it stays in the same cell?I found this [ 62. Spreadsheet tip: Change the behavior of the Enter key under File > Preferences > IBM Lotus Symphony > Spreadsheets > Input Settings.; ] it does not have no input settings though.John

More replies
Relevance 70.93%

Hello. I need help finding a solution to a specific problem I'm facing. I need to import data automatically from an Excel spreadsheet into a web-based form multiple times (over 300 times in fact) The data is neatly organized in the spreadsheet and each field in the web form directly correlates to a column in the spreadsheet. So I don't think this should be too terribly difficult to accomplish. The only problem is that in addition to text fields, the form also features drop down menus. But like i said, there is data in the spreadsheet that directly correlates to a selection in the drop down menu.

So, to put if briefly the following needs to happen:
1. The data is input from the spreadsheet to the web form.
2. A button needs to be clicked to submit the form.
3. A link needs to be clicked to bring the form up again.

This needs to be repeated until all the data is entered.

I think I've covered everything. I hope I've made it as clear as possible. Thanks a lot for your help! This would be saving me hours upon hours of work.
 

Answer:Automated web form data entry from Excel spreadsheet?

You could write an AutoHotkey script to do that. You would need to:

Activate the Excel spreadsheet window. (WinActivate)
Go to a particular cell in the spreadsheet. (Send tabs)
Copy the data. (Send Ctrl-C)
Activate the browser window. (WinActivate)
Go to a particular box in the web form. (MouseMove)
Paste the data. (Send Ctrl-V)

Then put all of that into a loop to run as many times as the number of cells to be copied. (Loop)

Submit the form. (MouseClick)
Bring up a new form. (MouseClick)

Then put all of that into a loop to run 300 times. (Loop)

The terms in the parenthesis like "WinActivate" and "MouseClick" are the actual AutoHotkey commands you would use.
 

2 more replies
Relevance 70.11%

Hi !

Can somebody please help with this problem?
I have to use a textbox to enter data into a form in MS access 2010
and use that data to search for a record in a table.?
In my case this is how it is supposed to be: ,whenever the user enters a date of birth,it will search in a table for all the families (identified by a unique family code) which have their baby scheduled to be born that day.and then it will return the matching family code.THis will then direct the user to a new form where they can enter new data.
I am really confused as I am new to Visual Basic.I am to manipulate tables until AfterUpdate event for the textbox.
Any help is appreciated.

Thank you for reading!!:
 

Answer:Regarding data entry in the form of a date into a textbox and using it to search for a record.

hey Aard
am not getting it right
but you can always use ms access query with parameter

if make the problem more clear it would good
 

3 more replies
Relevance 70.11%

Hello, I apologize if this is in the wrong forum, and if there have been threads about this issue before, but I've searched for a while and could not find a solution that I could understand from reading, as I am a newbie. Whenever I start up my computer, it shows this:
Windows failed to start. A recent hardware or software change might be the cause. To fix the problem:
1.) Insert your windows installation disc and restart your computer.
2.) Choose your languange settings, and then click "Next."
3.) Click "Repair your computer."
If you do not have this disc, contact your system administrator or computer manufacturer for assistance.
File: \Boot\BCD
Status: 0xc0000098
Info: The Windows Boot Configuration Data file does not contain a valid OS entry.
The computer runs windows 7 and is an Acer Iconia Tab W500, so it's a hybrid tablet and laptop and did not come with an installation disc, nor does it have a disc drive due to its size. I can't access the window that pops up with F8, the only screen that can appear is the F2 screen.
I'm fine with completely restoring the computer to factory settings, or pretty much anything that will get the device working again. The problem is, I can't figure out how to either repair the file or restore. I'm really sorry if this is really confusing or if I didn't provide enough information, I don't have any experience with computers, but any advice on how to fix it?

Answer:Windows Boot Configuration Data File does not contain a valid OS entry

Do you have a Windows 7 Repair Disk?
Do you have, or can you borrow, a Windows 7 installation DVD (Same version as yours)?

If you follow the instructions in that message using either disk the chances are good that you can repair the problem.

If you can't get your hands on a DVD, then when turn your computer on - tap on the F8 Key as soon as it comes on. When the black screen with options appear, select "Repair your computer." When you see the option, perform a Startup Repair.

If startup repair fails then select the last option which allows you to access a command prompt. You might want to enter these commands at the prompt:

bootrec.exe /fixboot
bootrec.exe /fixmbr
bootrec.exe /rebuildbcd

3 more replies
Relevance 70.11%

Not sure if this is the correct forum, please forgive me if I've posted it in the wrong forum.

Hi folks I?m a newbie to the forum and would really require some assistance, I?ve owned PC?s for a considerable time and I am pretty flummoxed with a problem I?ve encountered. I haven?t a clue how this occurred and for the life of me cannot seem to recover my PC. I have used various approaches on your forum to hopefully correct this issue but to no avail.

When booting from disk I get the message the file
File: \Boot\BCD Status 0XC0000098
Info: The windows boot configuration data file does not contain a valid OS Entry

I used the helpful guide ?How to Fix Windows When it fails to Boot? on this form and ran the following: Initially running system repair

The computer scans itself during this phase and looks for windows installations it returns the message no windows installations found. When I view the Diagnose and repair details I get the following:

No OS files found on disk
Repair Action: Partition table repair
Result: Failed error code 0X490

I have ran the repair process 3 times and booted between each repair

I progress beyond this and run the following:

Bootrec.exe /Fixmbr runs successfully
Bootrec.exe /Fixboot runs successfully
Bootrec.exe /RebuildBCD runs and returns successfully scanned windows installations
total identified windows installations: 0 completed successfully

My Laptop is a 4 year old ACER 8390G running Windows 7, it has a Hitachi 500Gb hard drive and the p... Read more

Answer:Windows boot configuration data file does not contain a valid OS entry

Hi jdoherty, Welcome to forums.

Check out this link. FIX boot error.

Hope this helps.

9 more replies
Relevance 70.11%

Hello,
my prblm is dat im doing a data entery work in .exe software and the software does not allow me to copy paste the text :( I want eanble that option coz very less time left with me to submitt the work please help me.

Answer:want to enable copy paste in .exe data entry software which doesnt allow me to do so

Somebody might be able to help you if you said what software you're using and where the text you want to copy and paste is coming from.

3 more replies
Relevance 70.11%

I have an Excel 2000 spreadsheet that contains an X-Y scatter plot. If I mouse over any of the points in the plot, Excel displays a little pop-up box that displays the data series name and the X and Y values of the selected point.

It would be very slick if I could click on the data point and have the row in the source data automatically recieve the focus or be highlighted in some way. In my particular case the chart and the source data are on separate pages of the workbook, but if the problem is solvable at all, it doesn't seem like this should make a difference.

Is such a thing possible?
 

Answer:Select or highlight data entry associated with point in scatter plot?

Aren't there any hotshot VBA programmers out there with at least an opinion on whether this is possible?
 

1 more replies
Relevance 70.11%

Hello
I am using a data entry software which is offline and i doesn't support copy or paste function so please help me i have very less time the software work like i should load a .jpg Format

Answer:Copy/paste doesnt work in data Entry software

.jpg is a picture not data

10 more replies
Relevance 70.11%

Hi,
I want to lock a range of cell ( Column) after data entry. Cell should lock automatically.

for example if D2= today(), then range of cell from D3 to D20000 is ediatble otherwise cell should be blocked.

No body can touch cell for yesterday or tomorrow...

cell should be open only for the date...

pl help, its urgent
[email protected]
 

More replies
Relevance 70.11%

Afternoon everyone!

I am trying to get a little bit of code working such that when a user enters in some data in column A, it triggers code in VBA to paint a simple surround black border over the whole row, from column A to M. Here is what I have so far, but it doesn't seem to be working. I know I am missing something (if not a lot).
Code:

Dim i As String

If ActiveCell.Column = 1 Then
If ActiveCell.Value <> "" Then
Range(Cells(i, 1),Cells(i, 13)).Borders.LineStyle = Excel.xlLineStyle.xlContinuous
Else
End
Else
End

I appreciate any help! Thank you in advance!
 

Answer:Solved: VBA in Excel: Automatically paint borders on data entry

Hi Maxx, you shouldn't forget to mention the version of Excel you're using

Place this code in the sheet
Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <= 13 Then
If Target.Value <> "" Then
Range("A" & Target.Row & ":M" & Target.Row).Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Target.Offset(0, 1).Select
End If
End If
End Sub
 

2 more replies
Relevance 70.11%

windows boot configuration data file does not contain a valid OS entry (0xc0000098)

Trying to fix my aunts laptop (Toshiba satellite/windows 7). Tried a recovery disc, which was painfully slow but no joy.
Here is screenshot of boot:
http://oi46.tinypic.com/2ut3kmb.jpg

Partition check with 'partition wizard':
http://oi46.tinypic.com/2z6tv92.jpg

I was able to explore the "system reserved" partition, which shows boot folder etc:
http://oi50.tinypic.com/34fdw79.jpg

When I explored the larger partition it only showed "(Disk 1 Partition 2)
http://oi45.tinypic.com/11iif5g.jpg

I did the diskpart thing in command prompt:
vol 0= E dvd rom
vol 1= C 100mb partition (active)
vol 2= D 232gb partition

Any advice on what to do to try fix this missing OS.
Thank you.

Answer:windows boot configuration data file does not contain a valid OS entry

If you ran Factory Recovery it apparently failed. Had you asked first we could have helped you work through the steps for Troubleshooting Windows 7 Failure to Boot. Now there is likely nothing to repair, although you can try Startup Repair after marking Win7 or its boot partition Active.

What I would do now is get and maintain a superior Clean Reinstall - Factory OEM Windows 7 . Everything needed is in the blue link.

If it fails to install, reset BIOS to defaults: Clear CMOS - 3 Ways to Clear the CMOS - Reset BIOS

While in BIOS setup set SATA controller to AHCI to try install. If that fails try IDE mode.

If install still fails try wiping the HD from the installer's Command Line using Diskpart Clean Command

Report back results as there will be more steps if necessary.

3 more replies
Relevance 69.7%

Hi all, I am new to your site. it very difficult to explain my request without using a spreadsheet so I posted my file and specification at below link

http://wikisend.com/download/481566/attachments_2011_02_12.zip

Can someone help me with this fairly quickly?

I would greatly appreciate it

Brian
 

Answer:macro to change source data of pivot table per user entry

Hey, nice service, could we upload documents using this?
 

1 more replies
Relevance 67.65%

Hi

Would anyone know how to extract info from web pages

I am interested in getting info from

http://www.famousroots.com/birthday/january.html

and creating an Excel File with column headings

Day
Month
Year
First Name(s)
Surname
Occupation

I would be grateful for any info, or perhaps someone knows of a more comprehensive source of DOB's

Thanks

Mike
 

Answer:Extracting Data from Web Pages

7 more replies
Relevance 67.65%

For my university project I've got to design an online library system (well at least part of it), using CGI written in C.I need to be able to pass the user's username between pages, rather than it having to be entered all the time. Now, I know that this can be done with hidden fields in a form, or by using cookies, but are there any other ways it can be done. If not then which way would you recommend ?The idea of using cookies seems the easiest, but is that likely to work with people choosing to block them ?The idea of using hidden fields strikes me as a problem because surely everything would have to go through a CGI program, rather than static pages linking directly to another static page. Presumably, the first page would have to be read, and then the new page generated with the same hidden field.Hope that makes sense.

Answer:Passing data between pages

I'd hate to be seen to recommend one method over another based on the very brief description of your requirements.Having said that, have you considered user sessions ?I love user sessions in any language - they offer so much flexibility to repeat instances of information already entered for your web programs.Just a thought.

10 more replies
Relevance 67.24%

Hello, I've been struggling with getting a simple InfoPath 2007 form to work with a test MS Access 2007 database. I feel the best way to explain what I am doing is by giving you an example.

Background of scenario:

Lets say I am a distributor of gas cylinders. I have 100 different gas cylinders that I fill and send to customers. When they are done with the gas, they return the cylinders and I fill them back up. Each cylinder has specific data related to each: manufacturer, serial #, specific cylinder ID, and material of construction (carbon steel, stainless steel, etc). I have this data in my MS Access database, in an individual table called "CYLINDER_DATA". Every time I refill a cylinder, I need to record the date and measure the pressure and temperature (among other things) of the gas in the cylinder. This data (along with the specific "CYLINDER_DATA" at this date of measurement) must be added as a new record in a different table called "CYLINDER_MEASUREMENTS" in the same database.

What I would like to do:

So, I want to create an InfoPath form for operators to use whenever they need to perform measurements on a newly filled cylinder. So, I created an InfoPath form, that starts with a drop-down list box control that is populated with the 100 different cylinder IDs. A user would choose one of the "cylinder IDs" from the drop down list and then click "retrieve data". This would then populate the fields directly below:... Read more

More replies
Relevance 66.83%

Hello,
 
Could I have some help please.  I opened an email and clicked a link from a person I used to know (thought it was safe).
 
Turns out it was a fake.  Someone had hijacked her old email address.
 
Problem is that some web pages load very slowly and whilst they are loading, data is being chewed through.  I'm nearly at my limit already.  Help!
 
 

More replies
Relevance 66.83%

I think I've asked this one previous but never rec'd an answer. For some reason when I call up help pages within Yahoo or Real VNC's mailing list to ask questions or other site, I get only a page with lines where text ought to be. Anybody else have trhis happening?
 

Answer:Empty data on web pages with no text

hook me up with a link and a screen shot of what you see would be ideal
 

1 more replies