Stopping Problems When A Field Name Changes

Nov 1, 2004

I have a database that requires new data from an Excel file every month. I have created a linked table, and the the user updates links each month, pointing the table at the new Excel file.

This has been working nicely until today when the Excel file arrived with different column names! The user linked the table as normal and started to run the database, but the queries were looking for different field names so the whole thing crashed. I changed the Excel column names and tried re-linking the table, but all the queries had changed so that the field names were things like "Expr1: [Depreciation_currentmonth]" even though that field name now existed.

Does anyone know of a way of stopping this happening, or restoring the queries without ploughing through each one manually?

Abi

View Replies


ADVERTISEMENT

Stopping Field From Getting Focus

Sep 19, 2005

I have 10 fields on a Form. When I load up my Form, I don't want any of them to have the cursor in it.

How do I do that?

View 5 Replies View Related

Stopping Pop Up Window Of F12 Key

Jul 20, 2007

In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?

View 2 Replies View Related

Stopping Email

May 6, 2005

I have a form with a command button which sends a message containing information from fields on the form. This works fine. Problem is, the user can use the "Email Button", when there are fields not filled in. Is there a way to stop the email message from being sent?

View 2 Replies View Related

Stopping Database Being Copied

Nov 8, 2005

I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?

Regards :confused:

View 3 Replies View Related

Stopping Duplicate Numbers

Jun 25, 2007

I've got an incrementing invoice number that is just a +1 of the last invoice number. Had a problem today where one user was creating an invoice and took a while to complete the record. As soon as the record was created the invoice number went in as 123 but the record didn't save until she had filled out all the form. In the meantime someone else started to create another invoice and ended up with 123 as well because the previous record hadn't saved. Does anyone have any suggestins how I can stop this from happening? I can't save the record straight away, which would be the obvious answer as they need to fill out quite a few required fields before the record is saved so that they don't have incomplete records.

Thanks

DBL

View 2 Replies View Related

Stopping Number Rounding Up

Apr 2, 2007

G'day All,

I have a table that allows for data to be automatically imported into it or manually entered. When data is automatically entered into the table the number field shows the number as a decimal, but when I manually entered data into the column it rounds it up or down to the nearest whole number.
I have checked the the decimal place setting on the particular item and it is set to allow for 2 decimal places the format is fixed and the number itself is Long integer

Any help would be a appreciated.

View 1 Replies View Related

Stopping Queries From Rounding Off

Dec 19, 2007

I have two tables. Table1 has two monetary value fields (both set with auto decimal places) and table2 has one monetary field. Then I have an append query which appends all data from table1 to table2, except for the monetary fields which are added up and then appended into table2's single monetary field (which also has decimal places set to auto). The formula I use for this is as follows:

Total Value: [Gross Value]+[Adj'mt Value]

Problem is, the total figure appended to table2 is rounded off to the nearest integer, whilst still displaying decimal places (45.00, 201.00 etc). Is there some sort of variable to set in the query to stop it from rounding off the result of this formula?

Any help would be appreciated.

Thanks.

View 1 Replies View Related

Stopping Duplicate Value Entries

Oct 17, 2006

I have a booking form database
With a date field.
I want users to be warned when they try to enter a date that already exists in the database in order to avoid double booking:confused: .....

all suggestions appreciated:)

View 4 Replies View Related

Stopping A Dropdown On A Combo Box

Jan 4, 2005

Quick question, (and hopefully a quick and easy answer).

I have a check box and a combo box. If the check box is not checked and a user clicks on the combo box, I have a message box that pop ups and informs the user that he/she must click the check box first. However, after they ok the message box, my combo box shows it's dropdown list.

Is there a way to stop the dropdown from occurring when they click on the combo box?

Thanks in advance.

View 9 Replies View Related

Stopping A Macro At The End Of All Records In A Form

Mar 28, 2006

I have a macro which automatically opens a form. I then want the form
to scroll through all the records by itself until it gets to the last
record.

I've got it scrolling through the records, but it doesn't know when to
stop and throws up an error message.

View 4 Replies View Related

Stopping Edits And Additions On A Particular Record

Apr 2, 2006

hi,

can anyone tell me how to stop additions and edits on a particular record in a form, plus the subform that the main form contains,
im trying to put the event behind the change of a text box, shipped date, so when its changed you cant add or edit the record which is the order.

cant anyone point me in the right direction?

cheers

View 1 Replies View Related

Stopping Forms Opening In New Windows

Dec 11, 2006

On my switchboard i've got several forms, whenever i click a link to a new form that form opens in a new window, how do i stop this so that they all open in the same window?

View 2 Replies View Related

Modules & VBA :: Do Loop Stopping Before Completion

Aug 27, 2013

I am using to select and append data to an output table. Everything is working fine until the last step. The last step appends all the data to an output table from the initial table. The intermediate steps select the data to output.

"AddExpenseToOutput()" is stopping about halfway through the list of criteria. Initially I thought there might be a null in the list, but it doesn't look like there is after dropping everything into Excel to manipulate.

Code:
Option Explicit
Dim rstAccount As DAO.Recordset
Dim rstAccounts As DAO.Recordset
Dim CAccounts As String
Dim Item As String
Dim AccountKey As String

[Code] ....

View 4 Replies View Related

Stopping Message Popups In Update Query

Dec 2, 2006

Hi again all,

Im wondering how I can stop the messages that pop up when im about to run a update query,

I get the following

1. You are about to run a update query blah blah....
2. You wont be able to undo the changes this action blah blah
3. You are about to update X Rows

Idealy Id love to be able to turn off the messages in just this query, and not globally over the whole database, can this be done?
Also, Id like to get a error if there is one.. so only stop those message that are currently showing...

Any help would be awesome,
Cheers Ezy

View 2 Replies View Related

Queries :: Query Stopping When Tabbing To Another Program

Aug 5, 2013

I have an interesting Access problem. When doing a query, and it does not matter which Access file it is all of them do it, if you tab out or click to another screen, sometimes, the query will stop. I have tried many different network related fixes but no luck. I am thinking the issue is with Access. I have no issue with Excel on Access files.

View 3 Replies View Related

Modules & VBA :: Auto-number Stopping Entry

Jul 4, 2013

I have a form that contains an autonumber field. Before any data is entered into the form that field displays the word "(Autonumber)".While it does this the subforms on my form that use that same field to run their querys are empty

Code:

Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec
[Forms]![InvoiceForm]![CreateNewRecord] = True
Me.AllowAdditions = False
[CreateNewRecord] is just a invisible tickbox that is used to enter some data on the form; I don't want to use it but haven't found another solution.

Anyway. When the user opens the form they have to press this button Unless a new record was previously created and that's confusing. I'd like it in the form load event except I can't "see" the value of the field while it displays "(Autonumber)".My code for the form load is:

Code:

If InvoiceNumber.Value = Null Then
Command82_Click
End If

Where invoicenumber is the autonumber field and command82 is the new record button.

View 11 Replies View Related

Modules & VBA :: Toggle Forms Without Stopping Code

May 20, 2014

I currently have two forms. One being my main form and the other being a pop-up form to update e-mail addresses. On my main form, I have a button that is currently programmed to generate several e-mails. Before those e-mails are generated, I would like the pop-up form to appear asking for any updates to e-mail addresses. Once the pop-up form is closed, I would like the code on my main form to continue.

View 2 Replies View Related

Forms :: Hitting Next Record Button Creates A New Job Instead Of Stopping?

Dec 28, 2014

I created a basic database in Access 2013 to keep up with jobs, and each job has a job number assigned to make each job unique (Primary Key).

At first I had it where I had to enter the new job number manually for each job. I have updated it and now it takes the last job number and adds 1 to it and then fills in the Job Number field automatically.

The problem is when I clicked the Last Record button, it will go to the last existing record, but if I click the Next Record button while on the last record, it will create a new record. It creates a new job instead of stopping at the last record. I assume it has to do with the auto numbering I have setup for the job numbers, since it didn't do this before, but I am not sure why. I ONLY want to be able to click the New Record (Blank) button to create a new job, NOT by also clicking the Next Record button.

Is there a way to force only the New Record button to add a new record? I still need the Previous and Next Record buttons to maneuver through the existing records. I just don't want to create new jobs accidentally by clicking the Next Record button when I'm at the end of the existing records. It should just stop, or say last record or something similar.

View 3 Replies View Related

Forms :: Copy Value From Field In Subform To Field In Main Form During Data Entry

Jul 18, 2013

How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.

In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.

So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.

View 10 Replies View Related

Modules & VBA :: Filter Subform Data - Only Show Records Where Field A Is Higher Value Than Field B

Oct 24, 2013

I want to filter my subform data, to only show records where field A is a higher value than field B.

Code:
Me.MySubform.Form.Filter = "A > B"
Me.MySubform.Form.FilterOn = True

This way it doesn't find field B.

Code:
Me.MySubform.Form.Filter = "A > " & MySubform.Form!B
Me.MySubform.Form.FilterOn = True

This way it seems to filter all record to the field B value of the first record.

View 5 Replies View Related

Inserting Time Into Access 2010 Query Field When Character Is Entered In That Field

Mar 4, 2015

Here is what I am trying to do. I have a query with 2 fields. "Time In" & "Time Out". What I would like to happen is this. Whenever a character, let's say a "t", is entered into that field I would like the current time to populate that field. Right now we are actually typing in the time. I have the fields set up as DateTime fields currently.

View 10 Replies View Related

Limit A Field To User Defied Values Depending On The Input Of Another Field.

Nov 23, 2005

Hey all,

I have two fields 1 & 2

field 1 is a simple combo list of user defined values ie A, B, C or D

Field 2 relates to a attribute of the data in field 1 and is not always the same for A, B, C and D. i.e

A could have a,b,c,d or e
B could have c,e,f,g or h
C could have a,g,h,i or j
D could have v,w,x,y or z

I would field 2 to have a combo box which only displays a,b,c,d, or e when A is chosen in field 1; c,e,f,g or h when B is chosen; etc

How do I do this?

Cheers all,

Matt :confused:

View 2 Replies View Related

Forms :: Can A Field Auto-fill From Previous Entry In Separate Field

Mar 21, 2013

I've just returned to work after kids and started managing a large Access database related to health, back-tracking over many years.

Currently in filling a form we physically enter:
Apples 2.2
red apple 2.4
red apple cut 2.45
Oranges 5.6
Cucumbers 8.5

Is it possible to get field 2 to automatically fill with a number code due to the text typed in field 1?

FWIW, I'm confident at more basic Access e.g making follow on default value = Dlast("field""table") type stuff but the more complex stuff I haven't touched since Uni over a decade ago and you will need to be gentle while I blow away the cobwebs

View 3 Replies View Related

Tables :: Auto Populate Field Based On Answer Of Another Field In Same Table

Feb 28, 2013

Within my table if Field 1 has an answer of Self (from drop down), then, I would like Fields 6-12 to auto populate; however, if Field 1 does not have an answer of Self, then leave Fields 6-12 blank.

I am not quite sure how to lay this out. I am using Access 2010.

View 8 Replies View Related

Forms :: Move Focus From Last Field Of Subform To Another Field On Main Form

Aug 19, 2015

I am currently stuck on set focus property. I have a main from with nested subform. I am trying to move the focus from last field of the subform to another field on the main form.

Customers(mfrm)....>Addresses(sfrm)...>Orders(sfrm Add)......>OrdDetails(sfrmOrders)

Now I have a field name [Securedesign] in frmOrderdetails and I want the tab order to navigate to field [CustomerID] in frmAddresses which is a subform to frmCustomers.

View 2 Replies View Related







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