I'm A Newbie On This Access Stuff...

Mar 23, 2006

I have a table (Master) that contains columns such as MsgLocation, MsgName, MsgScript, and MsgTxt. I want to create a form where the user would have an area to type in a 'string' and when they hit enter (or select a button), a (background) query would execute a lookup on master "where MsgTxt LIKE %string%"... For example, if a user wants a list of all MsgTxt values that contain "Please hold" they would type in a box "Please hold" and the query would use %Please hold% in the search criteria.

I don't have a clue on the first thing to do to get this done. And I'm new at this...

Thanks!!!!
Mary :)

View Replies


ADVERTISEMENT

Can I Auto Export Stuff From Word To Access

Jan 16, 2006

we run a family business and i do all the quotations.

i have an access database in which i record these quotations and whether or not we got the job or not, and i have to input all the data manually.

i wondered if i could set a word document so that it would automatically export certain areas of the quotation (like the date, who it was to, what work we are quoting for, how much it would cost, etc) into the correct fields in my database.

can it be done??

any replies will be much appreciated.

thanks

View 5 Replies View Related

VBA Stuff Up

Oct 16, 2006

In trying to write code to automatically hide database window I have completedly stffed up and now have code that closes the database window everytime I startup, hence closing the database.

Does anyone know how to disable VBA or somehow keep the database open??

View 1 Replies View Related

Wierd Stuff..

Oct 25, 2005

Recently I've been having a problem with Access (2003) that I can't seem to get around. If I click on "NEW" to create a new query, do some editing, then go to close, it prompts me as to whether or not I want to save, which would be ok, if it would let me choose NO!!

I only get OK or Cancel options. I've NEVER had this problem before.
I have not done any updates added any addons. Is there some hidden trick here or some way to get around this cause its really annoying.

TIA,
Tim

View 3 Replies View Related

Counting Records And Other Fun Stuff

Dec 5, 2005

Hey all,

I am building a database to help my unit in Iraq. Here are the fields I have so far.

Field 1: Date
Field 2: Time
Field 3: Location
Field4: SIGACT (Significant Act)

Well that is the basics look like. I would like to be able to count the number of times a type of SIGACT occured in durring the day, week, and month. I would like to have this come out in a report I could then take to Excel and graph. The SIGACT has a couple different options like IED, and SAF. Thanks for any help you can provide

View 5 Replies View Related

Real Basic Stuff I Cant Get Help

Mar 21, 2007

trying to join two tables but get message

"relationship must be on the same number of fields with the same data types"
data types are same, numbers.

Primary table has just jobnoID that are all unique (primary table)
ie 6907, 6908, 6909 etc

second table "jobs by order" (secondary table)
has
unique orderno(order numbers) in column one say 69071 and 69072, 69073
and jobno in second coloumn say 6907, 6907, 6907 for all the above.


trying to link JobnoID primary table (one to many) to Jobno secondary table (many)


Also need to note. This database is a purchase order database. so am trying to load in all past data from excel. data is in already. so primary table above with jobno is an auto number so will generate the new jobno for us. but had to copy and paste blank fields into table to get records upto the number we are upto now, ie job number 7112. I have only put data in secondary table for
jobno's 6885 through to 7112, and even some of these have blank spaces.

Any ideas?
Also how do i do a screen capture and dump in here so you can see relationships etc, which would be a whole lot easier to explain. thanks heaps
Alastair:rolleyes:

View 4 Replies View Related

Help With Msys Stuff And Forms

Aug 26, 2004

I am trying to create a Switchboard of my own that will do everything the database window will, but restrict certain users from accessing certain areas of the switchboard. The only part i am needing assistance on is Adding, Deleting, Modifying and Running my database items from the form.

I already have used that MSysObjects code to create list boxes for my Tables, Queries, Forms and Reports. Now, I'd like to setup 4 custom command buttons on the form that say:

Code:Private Sub AddTable_Click () [listTables.Value = New Table, prompt user for standard New table wizard]End Sub Private Sub DeleteTable_Click () [listTables.Value = Delete this table (with normal "Are you sure" prompts)]End Sub Private Sub ModifyTable_Click () [listTables.Value = Open this table in Design view]End Sub Private Sub OpenTable_Click () [listTables.Value = Open this table in Datasheet view]End Sub

Now, I know that this code is by far not the correct code, but I hope it helps you understand what I'd like to do. Basically, I want the button to correspond with whatever is selected in the list box for that item (except for the add button, it really doesn't matter what the listbox says when the add button is pushed). As far as my list boxes go, i'd like 2 functions for it to do:

1. If a table/query/etc. is double clicked, that item is opened.

2. Allows multiple selections to delete. (i.e. the user can select multiple tables and click the Delete button, and all the tables that are selected are deleted.)

Let me know if all of this can be done from my form. It would be great to get all this working by tomorrow. I appreciate all of aspfree's users help. You guys rock!

View 3 Replies View Related

Pivotables, Date Controls And Other Stuff

Mar 11, 2008

Can someone please, please help me on here?

If there are any aspiring `idiot´s guide` writers out there, now is the time to put some practice in!

I have almost completed my database, I just need to get the reporting section done.

I need to produce a monthly report on our casework which basically means totalling certain fields each month, which are exportable to access so I can produce comparison graphs.

I know that you cannot ´total´ text fields except for when you produce a form based on a pivotable. Is there anyway of producing a pivotable from a user-selected date range, and then being able to export that pivotable to Excel for the monthly report? Also, can I put a user-selected field filter in the pivotable?

So for example, my user wants to know how many cases there were for each subject in the month of March i.e. how many health enquiries, how many benefit enquiries, how many pension enquiries and so on. Each of these different types of enquiry are coded in a field-list called ´subject´. Therefore, can I produce a pivotable based on the selection of a date range and the field called ´subject´?

I am against a desperate deadline to get this done now. If anyone can spend time spelling this out in little words for me that would be great. This is the first time I´ve used Access and I ain´t done half bad, but this is completely stumping me!

Thanks in advance.

View 4 Replies View Related

Making Buttons Do Fancy(?) Stuff

Nov 22, 2005

I am trying to add a 'keypad' to an access form. The aim is to have an entry system similar to the tills you get in some pubs where when you click on the relevant number it enters that number in the selected field on the form.

I know this is probably a basic question for most of you but your help would be very much appreciated.

Derf

View 2 Replies View Related

Forms :: Copying Multiple Records From One Table To Another And Other Stuff

Sep 5, 2013

It basically is used to create, manage and track Customers, Parts, Work Orders and Suppliers, payments and employees.You simply create a Customer and then create a Work order that contains a list of parts and labour items.

What I want to do is to create a "Kit" of parts so that the user does not have to select each part individually when they create a Work Order. For example, if I use a mechanics workshop as an example, the mechanic may sell his "Signature 1916cc Engine" that consists of 40 different parts and some other items such as labour and other services. In this scenario, instead of the user individually selecting 40 different parts, all he needs to do is select the Kit called "Signature 1916 cc Engine" from a drop down list and all of the 40 parts and other items would automatically populate the correct Work Order Parts/Labour tables.

I would also like the user to be able to select another "kit" that would either replace all parts and labour records or append to what is already there.

I have changed the form called "Workorders" to have 2 buttons. One called "Load Kit" the other called "Save Kit".If the user presses "load Kit" a form will be displayed that enables them to select a "kit" from a list and whether they want to replace all of the existing parts and labour records or if they want to append to the existing records.

In order to create a new kit, the user can simply manually create a new work order by individually selecting each part and labour item and then pressing the "Save Kit" button. The user will then be asked to provide the short name of the Kit and the long description (I have created table called tKit). The new kit will then be saved.

It appears that the "Entered by" field that is linked to the Employee table must not be blank other wise the Workbook is NOT saved....I have tried to figure out why this is happening but can't!

The Work Order Parts are stored in "Work Order Parts" and the Work Order Labor is stored in a table called "Work Order Labor". I have created 2 extra tables called "tKitWorkOrderParts" and "tKitWorkOrderLabor" that I assume will contain the items that make up the kits..

View 14 Replies View Related

Access Newbie Needs Help!!

Mar 21, 2007

Hi,

I'm designing a database for work and am using buttons instead of the navigation features already standard with access.

I need some form of code?? for my button. I want a user to be able to click this button when finished entering data; access will then save the data, close the form and return the user to a main menu, like a switchboard.

Any suggestions or indeed code, lol, would be very helpful

Regards

Chris D

View 3 Replies View Related

Newbie Having His First Go At SQL In Access

Oct 11, 2005

Ok, I've been given a task to create a hierarchy diagram for my company, unfortunately the diagram has to be created using one excel spreadsheet. I would prefer it if the database could be created using the smallest amount of user input, so all he user has to do is import the spreadsheet to access and hit a button then the hierarchy is created.

I'm currently only going one step at a time, trying to sort the data from the spreadsheet using queries. But this is the problem:

Raw Data table
ID, Firstname, Lastname, Status, SupervisorFirstName, SupervisorLastName

Table1
ID1, Firstname1, Lastname1, Status1, SupervisorFirstName1, SupervisorLastName1

The idea is that the hierarchy diagram should start with the boss and move down to the mere siblings like me, and everyone will be connected. But for one reason or another this isn't the case, so at the moment I am trying to move the persons record if their supervisors name is not in the tree, so the SupervisorFirstName and SupervisorLastName are not in the Firstname and Lastname column.

I have been using the following SQL

INSERT INTO Table1 ( ID, LASTNAME1, FIRSTNAME1, Status1, SUPERVISORLASTNAME1, SUPERVISORFIRSTNAME1 )
SELECT ID, LASTNAME, FIRSTNAME, Status, SUPERVISORLASTNAME, SUPERVISORFIRSTNAME
FROM RawData
WHERE (((RawData.SUPERVISOR_FIRST_NAME)=FIRST_NAME) AND (RawData.SUPERVISOR_LAST_NAME)=LAST_NAME);

When I change the LastName to "SMITH" I know how many records I should get and it works, but how can I go through both columns finding any matches??

I may have described this quite badly so if you need any more info please let me know.

View 3 Replies View Related

Newbie At Access Needs Help

Jun 29, 2006

Hi all,

I'm just having a dabble in VBA for Access so I'm fairly newbish!

I have a field [Reference Number] that increments in the table by 1 everytime - but the user has to enter this manually (its not auto-incrementing). How can I do the following: when the user selects a new row in the table it will automatically look in the table for the last entered [Reference Number], increment it, and put that value in the Userforms TextBox??

Hope you understand this,

TIA

View 5 Replies View Related

Access Newbie

Jul 12, 2006

I hope this is the correct place for this type of question.

I have two tables, let's call one the "record table" that holds each record of interest. Let's call the other one the "rule table," as each entry is a "rule." The two fields of the rule table are rule and description.

I have a form with a list box and a text box. I'd like the user to be able to choose a rule from the list box and this would control the "rule" field in the current record. However, I'd like the text box to display the description corresponding to that rule, by looking it up in the rule table.

I know I've probably made it sound very complicated, but I assure you I'm trying to do something very simple here. Thanks for any help anyone can give me!

View 10 Replies View Related

Access Newbie Help

Oct 5, 2006

I am fairly new to Access, so please bear with my hopefully easy to answer questions. I am trying to create a database for a university where we input all of our student leaders information (name, email, student ID number, etc) along with the groups they are involved with so we can track and see who is involved with alot, and so we have easy access to their contact info if we need to do that. Anyway, I have already created a database to take in all the information and spit out the reports. It is probably pretty messily put together, but like i said, this is my first time working with Access on this scale.

My question is, when I created a report to display all the students involved with a specific activity, I ran into a bit of a problem. There are two students with the same last name, and for the activity in question, they both should be shown. However, it only shows one of their names (I have it set to show the last, first) but it shows both of their activity status. What am I missing to be able to split the names show its shows both names?

Here is a link to download the access file, and perhaps someone can tell me how to fix it.

http://us.f13.yahoofs.com/bc/440a2a54me2cd2c62/bc/access/Involvement+DB.mdb?bf8mTJFBardSN6ge

All of the sensitive information has been removed. It will still work without it though.

Thanks!

View 3 Replies View Related

Newbie Need Help With Ms Access

Apr 27, 2007

I am trying to learn first how do i lock a db so that it will keep users from tampering with the forms and queries, second i am trying to learn how can i transfer the form, queries, etc. to a new ms access database without having to recreate them all over again. I recieved updates from a source of mine and it contain new information, the old database is archived. And the new db with new information is keep separate from the old information in the new database so i had to recreate the form everytime.

View 1 Replies View Related

Newbie VBA Access Question

Aug 24, 2004

I've been looking through the help for this.. but I can't figure it at all...

Simply... I've set a click method for command button on form to requery some fields. In effect it's a refresh.

What I would like to do it set the same command buttons gotfocus method to call the click sub.

Private Sub Refresh_Click()
On Error GoTo Err_Refresh_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Me!SelectMSN.Requery
Me!LesseeSubForm.Requery
Me!ReviewSubForm.Requery
Me!InsSubFormQuery.Requery
Me!SecuritySubForm.Requery
Me!AssetSubForm.Requery
Exit_Refresh_Click:
Exit Sub
Err_Refresh_Click:
MsgBox Err.Description
Resume Exit_Refresh_Click
End Sub

Private Sub Refresh_GotFocus()
Refresh_Click
End Sub

Reason being the gotfocus is called from another 'input' form and I want to data to be visible in main form after a save/close button i've created.

Thanks.

View 2 Replies View Related

Help ASP Newbie Connect To Access Db Please

Nov 30, 2006

Hi

I'm new to ASP and I need to connect my webpages to an Access database I have created. I would do this in dreamweaver normally but I'm having trouble using the custom connection string function to do this. So I was hoping someone could explain how I would do this by coding it instead.
The code my web host provide to connect to a database is below. If someone could explain to me how I would use this to connect to a database, I would be very grateful. Thanks.
Quote: Dim oConn, sConnection

Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:sitesSingle??UserNamedatabasedata.md b;" & _
"Persist Security Info=False"
oConn.Open(sConnection)

oConn.Close
Set oConn = nothing

View 3 Replies View Related

Newbie Question, Can This Be Done Is Access?

May 11, 2007

Hi to everyone firstly!
i am a firefighter, we have a set number of personnel on my watch, we work 3 days of duty, each day of duty each member of the duty crew are allocated tasks, not everyone can do all of the tasks!

the tasks are :-

one person drives the fire truck
one person drives the aerial ladder fire truck
one person fills the other crew position on the aerial truck
one person is the duty-man for the day


not all personnel can do everything, some don't drive, some can't drive the aerial truck but can be the other crew position

if we have more crew members than we need one or more may be sent out to another station

what i want to know is can a data base be set up, entering data to state who did what on each actual duty day and then the database will make a report to say which watch member is next to take a turn in each position?

there a some variables, some can't drive any fire truck, some can drive the fire truck but not the aerial truck and two personnel can't be on the aerial truck who can not drive it!

sorry if it doesn't make sense!!!!

i do have a vague outline knowledge of access, i can fill tables create forms and switchboards, do basic queries and reports

many thanks

Pete

View 6 Replies View Related

A Newbie Question About Access Security

Nov 2, 2006

Hello, i have a frontend DB linked to a backend DB wich contains tables, and i want to create 2 kinds of profile : those who can do everything (add,delete,update) and others that can only consult. Here is my question : is there an object to see if i am using the profile 1 or profile 2 and can i swap them using VBA code when i launch my program DB ?
Thanks in advance for help.
VINCENT

View 8 Replies View Related

Access Version 1 Advice For Newbie !

Dec 26, 2006

Hi everyone,
I have a very old Access Database (version 1) which I need to open however I only have Access 2003.

Do I need to buy an old copy of Access or can I download it anywhere ?

P.S - IT is not my strong point so I hope it's simple...


Many thanks
Pat

:confused:

View 2 Replies View Related

Newbie: Designing A Database In Access

Nov 1, 2005

Hello,

Hoping some one could assist me? I am busy designing a database which I am going to put in access.

I have designed the tables and am now not sure how to link them. I was given an excell spreadsheet with headings and am now trying to make this into a database. Example : I was given Co-ordinator Name - Which I now split up into:

Co_First_Name
Co-Last_Name
Co_Initials
Co_Area_Code
Co_Tel_Number
Co_Mobile
Co_Email


Now there other fields like this , for example Regional Manager Name - which I have split up as above into a seperate table.

These fields all relate back to one Code - Called District

There are also a fields which needs to show the a fee required the fee paid and fee outstanding/balance .

The rest of the information required I can create check boxes for , I hope!
Anyway my question is how do a relate all these different tables together?
This is my mental block. And the check box tha information - is it stored a another table? I hope I am explaining my self correctly and I hope some one can make sense of my question

View 4 Replies View Related

Couple Of Newbie Access Questions

Jul 14, 2006

Okay, I have two questions.

First, if I have a table, and I want to combine two records together, how would I accomplish this? For example, say I have the following table.


NAME SALES
Bill 2000
Jim 500
Ted 1000


And by some miracle of science, Bill and Jim are able to fuse together to become Jill, combining their sales together. So the new table would look ilke this.


NAME SALES
Jill 2500
Ted 1000


My second question is, say I have an extended list of the same table with 30 names and corresponding sales. However, I want to find out Ted's percentage of sales of the TOP 15, not all 30. How can I accomplish this?

Thanks so much in advance for helping out a complete newbie. :)

View 9 Replies View Related

From Form To Query - Access Newbie

Aug 24, 2005

Hi all. I am fairly new to access and am trying to do something that shouldn't be that hard. I have a simple form with one text box and a command button on it. I have the command button set to run an update query.

My problem is that when I enter data and press the button, I don't know how to get the entered data into the query?

I know this is simple to do, but since I am new to access, I can't figure it out. Does anyone have a simple example or step by step details that they can share with me?

Thanks

Chris

View 2 Replies View Related

Newbie On Retrieving Autonumber From Access

Jun 10, 2005

Hi all, I am new to working with databases. My question is, how do you retrieve the autonumber ID of a field for a row just inserted into a database.

I have read numerous threads/articles, but none give me a clear picture of what the code actually looks like, just pieces(which is like greek to me). Could somebody tell me where I can see a working example of the code?

Thanks,
Mike

View 3 Replies View Related

Access 97 - Query Help - Newbie - Removing Duplicates

Jan 25, 2007

Hi,

just finding my way in Access 97 with no real support. I have made a query that creates duplicate records when I only need to see one for a certain criteria (lets say criteria X). This is due to the data feed involved in making the query where criteria X is found in numerous records.

What I want to display is only one record per entry containing an exact match for criteria X.

Finding it hard to articulate this but I would need something that defines:

If criteria X is the same, just display one record.

Hope this is somehow clear as I am struggling a bit. Would be gratefull of some help.

Thanks

View 3 Replies View Related







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