Search results for query: *

Hello Guys, First of all, I have a form with several fields. Two of those fields, I set them as Ole Objects. They are going to hold wave files. On the form, I right click on the; for example one field, then a pop up window shows. I choose "Insert Object" then " Create from File" then I look for...

First of all, I'd like to say hi to all you people. I have a bunch of tables that are all linked. There is a one to many link that I'd like to change it to a one to one. How do I go about doing that? On the E-R diagram session, when I drag the field (PK) to the other table (foreign) Access makes...

Hello, Currently, I've created 5 tables. I want to create a form for data entry. I placed a few drop down boxes onto it along with some text fields. I want those boxes to pull the info from their corresponding tables. I can not get it to work. For example, when someone is doing data entry, I...

Why am I getting an indeterminate relationship? I have this table that I want to join as a many to many relationship. How do I go about doing that?

I need some help or suggestions I have to build this database, I was thinking on using Access. The form will have about 12 fields. I'll collect customer information data and populate the database with it. A field is going to be storing Wave files, is that possible in Access? Every month I'll...

This query is a little messy. I'm trying to calculate a total for the whole . Right now, it does calculations on a monthly basis.(I have to tell which month I want) I'd like to build up the query so it calculates a total for all the months. The db contains info from june-2002 till the Present A...

I just added a new record to my DB and when I run an existing report, the data for that particular record does not show. I have two tables and they are linked by an id. The new record contains a new ID. If I create a query and run it, it shows but when I run the existing record(from the...

Hi, I have this query, SELECT Deployers.Deployers, Deployers.Population, Sum(Statistics.Tot_calls_by_Month) AS System_Total, Deployers.Months_Operational, Max(Statistics.Tot_calls_by_Month) AS PMTot, Sum([Tot_calls_by_Month])/([Months_Operational]) AS AvgPM...

Hello, I have this table with a autonumber(PK). I just noticed that there are two rows missing. Didn't miss any data. My concern is where are the two rows? Will that create any problems later on? This is what I mean, 525 526 527 528 529 530 533 Thanks

I have this query, UPDATE Deployers SET Deployers.Months_Operational = Deployers.Months_Operational+1; At the beginning of every month I run it and it increments the months by one. Is there a way where I can set it so it does it automatically in the background Can a macro do it? Thanks

What can I do to make Access to do the job. Every month I have to enter data into this DB and at the end of every month I have to run some reports. There are more columns similar to the one below with different values. For example, The one below, I have to count the values that are non zero, add...

I went to the start up and unchecked everything. how can I get that back? Now, when I run it, it runs but I can't get to the design part of it.

I created this form for security purposes, and on the button ( Enter ) I did this Private Sub cmd3_Click() On Error GoTo Err_cmd3_Click Dim stDocName As String Dim stLinkCriteria As String Dim txtPasword As String txtPassword = "7389" stDocName = "Switchboard"...

My Db was working fine until now, it won't show the DB Window. It's giving an error. When I debug, it takes me to this Me![Option1].SetFocus " Can't move the focus to the control Option1 How can I fix that? I went to the start up and it's checked

I have a switchbord, when someone clicks to see one form, that form opens up, if the person tries to go to another form from the second form it can do so but the second form won't hide or dissapear,it stays there. how can I make it dissapear? Is the problem in load or unload of the form?

I'm trying to create thi DB on some statistics. I have two tables but I think I can only do it with just one table. I've already imported the data from excel. This is what I have, Table1 MMDDYY (PK) Table2 MMDDYY (PK) Hour0 Hour1...

I went to see the books that Barnes And Noble has on Access, and they all sucked. Does anybody knows of a book that's worth buying? Please, I want the Title. I looked for information on Nz and IFF function and none of those books gave me what I was looking for, Examples on how to use those...

Is this syntax oK? I created this text box in the Report design view and added this =Sum([Total])*Sum([Average_call_length])/18/60 I'm not getting the right answer?

I have to create a report on this query. There are some fields that have zero values and some don't. I want Access when creating the report and displaying the results to not show the values that are zero but show the ones that have numbers and all the Deployers. An example, A 23565 B...

I have all these queries and I have to do reports on them. I'd like to split up the work with my collegues. Can we all work on the reports on separate db(same db, different computers) them import all the reports into the main db? Thanks,