Search results

Hi there I have a vendor that emails me the results of blood tests on a daily basis. I wish to import the data into Access, but the field names are not valid MS Access names. The field names contain reserved names, leading/training spaces, letters and characters etc. Strangely enough, I am...

in short - Yes, but instructions on how to that differ, depending what version of access you are using. Search the forum for accdb and mde files for your version answer

Have a look at InfoPath - It does EXACTLY what you are wanting. You create a form that sources data from the database. When they update and return the email, the DB gets updated. NOT: You will need to tell them to SEND the email back.

Have a look at this thread - it may help you. http://www.access-programmers.co.uk/forums/showthread.php?t=227838

Sorry - it still seems to be missing objects. See attached image. The objects in the relationships table refers to objects that are NOT in the database (see the object browser on the left.) Also, the form that you are asking about (Titled "Tissue Registration") opens when I click the "multi...

Does it help to do the following? Create a query that gets its parameter from CboAgency. Set the CboAgency After Update event to refresh the query. Then the rowsource for CboPgm is set to the query.

Are you able to post your db so that we can see what you're trying to do. I think that I am not understanding exactly what you want to do

Your database does not have all of the required objects. Open the relationships manager and then compare this list to the objects that are in the object exp[lorer (on the left hand side)

Hi Mohamad Are you not complicating matters by having so many tables. Could you not simplify it down to (at least) PROVINCE if not City Name? For example, If One table had continent, region, country, province as fields (Combined, they are the primary key), You could reduce the overhead by simply...

Have you thought about splitting the db into a front end and a back end. That way, you should both be able to enter data almost simultaneously. If a record id being used by person A, the record will be locked for person B until A is finished with it. Splitting the DB should take care of the...

Hi Allardaccess I cant open your db right now, (using Ubuntu at the moment) but I suspect that the combo box is sourcing data from another table. If you right click on the combo box and choose properties, look in the format tab, Find the properties called "columns" and "column widths" Set...

Hi Aussie. Sorry, I don't have an answer, but see a potential issues that will cause you endless problems as your programming skills improve. Its standard practice to name tables and fields without spaces.(DBs dont like spaces in names) Either use underscores (_) to join words like...

Hi. From reading your mail, I think that you may need to normalize your data. And create a third table. By "normalize", I mean that the ITEMs table has only ONE record for Each item and likewise, the REGION table has only one record for each region. Now the third table should contain at least...

I may be wrong, but I think your problem is the last exclamation mark in . . . WHERE (((EmpQ.StaffId) In ([Forms]![Accounting Report]![tbFilter]))) Should it be a full stop? eg . . . . ([Forms]![Accounting Report].[tbFilter])))

I have a query that appends student information from the school admin database, to a table in my database. The school db is accessed via an ODBC connection. On one of my forms, there is a button that say "Update Student Data" When the user clicks the button, a macro makes a call to the query...

I knew there had to be a way - Thanks

Hi readers I have 4 tables as follows. TblBCode - Barcode, BCType TblUsers - Users, UserGrp TblHardware - SerialNo, HWType, and some other fields. TblHWTypes - HWType,Description I want to ceate a query that selects all records in TblBCode where BCType is not in TblHWTypes.HWType I think it...

So them the following concept should work if you attach it to the EXIT Field? Just change the field names / conditions that apply to each field. if me.fieldname.value = "Youth" then me.YouthField.setfocus else me.Adultfield.setfocus end if

Eureeka - I found the answer. Do NOT refer to the subforms by its name, but rather use "NavigationSubform" as follows. [Forms]![Frm_Switchboard].[Form]![NavigationSubform].[Form]![NavigationSubform].[Form].[MachineID] I was using...

Hi Robbie 1234 I would consider 3 options. The first, is to manage the data via vba (as per you existing design) The second, is to put your questions into another table, and have 1 field that identifies "Adult" or "Youth" - Then create a query that selects either the Adult/Youth questions...