Simple Yet Important PROBLEM

Jun 10, 2005

I currently have a database and I would like to add in page numbers. I tried the built in functions but they did not work and they are not exactly what I am looking for. I want my page number to look like this:
"1 out of 12 records for MICROSOFT"
So I need the counter to know how many records exist for a specific client and keep track of which one of those records are being viewed. Can anyone help?

View Replies


ADVERTISEMENT

BE/FE Security *Important*

Mar 12, 2006

i have an access application in fe/be environment. I have put the BE in a shared forlder on the network.

Now the problem is that the shared folder where the BE is stored, has full read/write access. And this folder is visible to all users on the network from their network neighbourhood or through the mapped metwork drive.

So the problems are:
1) The shared folder has read/write access, so anyone can delete the BE mdb file. <<<<< main problem >>>>>

2) As this folder is visible to even those users who do not use this softaware, anyone can see the data.


We are using winxp and win98 on our network.
What can i do to secure the BE mdb file?

View 12 Replies View Related

2 Important Questions

Nov 13, 2005

Hello,

>> How can i get all the results if no input parameter is put in the query e.g. if i have A,B,C and need to get all results, only A, only B and only C?

>> How can i block 1 cell and only acess it if the last cell have a correct value?

Thanks in advance,
Kobee

View 3 Replies View Related

IMPORTANT - Help With Access

Jan 16, 2005

I was wondering if anyone could help me. I am designing a database for a bowling alley as a project and I am wanting to know if there is a way of doing a search which will bring up all lanes which are unbooked. I have got a search which brings up all lanes booked in ascending order but need a more detailed search. Hope someone can help and if this does not make muc sense please contact me.
Thanks!!!

View 2 Replies View Related

Hiding The Important Bits

May 9, 2005

Hi,

I've developed my little database and it works a treat... now I want other people to be able to access it input info via forms (add data), and see reports and run searchs etc... all of which is done through a central switchboard menu.

What I dont want is other users getting into the setup of it all - basically i just want to hide the background workings, relationships, queries etc so nothing can be messed up...

What can i do, and how?!

bear in mind, i still want to be able to have full access myself.

Cheers

amx

View 3 Replies View Related

Disabling And Enabling A Button. PLEASE HELP, VERY IMPORTANT

Mar 14, 2007

Hi, I have a form called Product Details Display Form, which is for Product Details Display table. This form contains a button "Done" which saves everything into the table, or in other words, bounds the unbounded textboxes to the table. Basically, I want this button to be disabled at the begining, when the form loads, and when the user enters ALL the fields, it becomes enabled. Here is the code I have at the moment:
Private Sub Form_DataChange(ByVal Reason As Long)
If Me.Product_Brand = Null Or Me.Product_Code = Null Or Me.Product_Name = Null Or Me.List34 = Null Or Me.Price = Null Or Me.Details = Null Or Me.Discount = Null Or Me.Combo0 = Null Or Me.Combo2 = Null Then
Me.Command36.Enabled = False
Else
Me.Command36.Enabled = True
End If
End Sub

I also have Me.Command36.Enabled = False in the Form-Load. I dont really know if it has to be in Private Sub Form_DataChange or not.

Please help me ASAP

Thanx in Advance

View 4 Replies View Related

Important Notice To Vista Users!

May 28, 2007

Important notice from Micro$oft's Knowledge Base:

When you open or are using a Microsoft Office Access database on a computer that is running Windows Vista, you may encounter one or more of the following issues:
• Access appears to stop responding.
• Access responds very slowly.
• Access exits unexpectedly or crashes.

For the complete article and possible work arounds goto:

http://support.microsoft.com/?kbid=935370

View 9 Replies View Related

Text Color For Urgent Or Important Items

Jul 2, 2012

How do I set the text color in one field as Black for regular records & a different color for Special records?

View 1 Replies View Related

Need Some Important Help To Get Added/modified Rows From Access Tables.

May 23, 2007

Hi,
I have a 3rd party desktop application to manage inventory. The data will be stored in local MS Access database. I want to sync any changes (insert, update or delete) made to this database to remote MS Sql server immediately or in batches using a scheduler.

Is there any method to know the changed rows in an MS Access table after x time. I mean I want to get all the rows in an Access table that have been added or modified after a particular date and time (say "05-23-2007 10:15:00") without using a user defined date time column in that table.

If i can do the above operation, i will write queries to get the added or modified rows and update remote server in batches.

Thanks and Best Regards,
Anz

View 1 Replies View Related

Simple Question For A Simple DB

Dec 29, 2006

Ok I am right now making a simple Vendor/Product database to create a line sheet for some sales folks. I have 3 tables: Vendors, Products, and an associate entity Vendors_Products to relate the two. I have a form currently that draws the Vendor Name (primary key) from the Vendor table and the Product Name from the associate entity. This allows me to create new vendors and select current product types from a drop down box. The problem is that the drop down box is too long and it is tiresome when 1 vendor has 10 product types.

Can anyone tell me how to resolve this? I thought it would be better to have option buttons and display all available products. Then you could just click all of the option buttons that apply to that Vendor and it would create the relationships...is this possible?

View 1 Replies View Related

A Simple One For You All

Nov 22, 2005

Hi,
I have looked at some of the threads here and it is clear that many of you are working on a much higher level than me and with a high degree of familiarity with the programme.
I am hoping that someone here is able to give me some advice as I don't find the MS help files digestible.
The task I have is to join 2 databases and produce a table from which I can run a mailmerge.
I have managed to join the 2 databases and I used a customer ID as a common link. (my apologies if the terminology is incorrect)
I now have all the data I require in one table.
THE PROBLEMs I have multiple entries for some of my customers and would like to reduce this to single entries (which is understandable). Please tell me how to do this if you can, and keep it as simple as you can please.

In anticipation I thank you very much.

:-)

View 2 Replies View Related

Simple One But Not For Me!

Jan 14, 2006

Hi there,

I'm making a report detailing competitors final finishing positions in a competition.

The columns are (1) Place, (2) Name and (3) Points

I have the data for their names and the points they have scored, but how do I make the table enter the record number (starting at 1) in the first field???

Thanks in advance
Col

EXAMPLE

PLACE NAME POINTS
1 John Smith 199
2 Ian Jones 90

View 1 Replies View Related

This Should Be Relatively Simple?

Feb 16, 2006

Not sure what the issue is here but i am trying to append a Job number from a main database into two connected databases.
The number is a sequential number i have created and the primary key.
It is an autonumber field(obviously). The format is J0000 and the numbers start from J0001

I am using two different append queries to append them into the external databases tables.
However (and here i think lies the problem) the fields i am inserting them into are text fields with the same format J0000.
When i view the numbers in these tables, they are displayed as J1 or J9. The 0's are missing.
Any ideas.

Thank you in advance

View 10 Replies View Related

This Is Probably Really Simple!

Feb 21, 2006

Hey guys, I'm just wondering how I could limit a field to using from 2 - 20 letters. If I placed the letter "a", I'd get an error saying how at least 2 letters must be there, and a maximum of 20. How would I do this?

Lastly, how can I make it so when I enter data into a form, I can click a button which adds it all into the table?
When I do it normally, it's automatically transferred into the table as I type it into the form.

This is incredibly simple I know, but I am a n00b at Access. ^_^

Thanks guys.

View 2 Replies View Related

Should Be Simple.....

May 18, 2005

OK, I have a strange problem... This doesn't seem to work..... It did... then I made some changes.... Can someone clue me in on what I am doing wrong? A query, simply summing some values in fields... no biggy...... BUT...
The field
TotalHours: ([SundayHours]+[MondayHours]+[TuesdayHours]+[WednesdayHours]+[ThursdayHours]+[FridayHours]+[SaturdayHours])

So why isn't this working?
Can I use a simple VBA statement to sum these fields?


:confused:

View 14 Replies View Related

Simple Qns

Nov 24, 2005

hi all, this is my problem:

i got a table like this

ID time in time out working hours
1
1
2
2
the working hours is [timeput]-[timein]

how to i create a query so that all the ID 1' s working hours will be summed up ?

View 4 Replies View Related

This Should Be Simple

May 15, 2006

:confused: simple query
Critera : <Date()-30 should show records from the last 30 days ???

and : "status"="active" should show records from the last 30 days that are active ????

or am i totally off the mark here ?
vey new to this be gentle :eek:

cheers

View 14 Replies View Related

Probably Something Simple

Oct 18, 2006

I am trying to create an IN query (ACCESS) which will firstly show the customers table (specific details) then the orders details should be in the IN query, I formulated this but it won't work:

SELECT s.CustomerID, Address, City, PostalCode
FROM Customers s
WHERE
s.OrderID IN
(SELECT s.OrderID FROM Orders p
WHERE s.OrderDate = '1996')
AND
s.OrderID IN
(SELECT s.OrderID FROM Orders p
WHERE s.OrderDate = '1997');

Here is the one I did to show the customers and orders who made orders in 1996 and 97:

SELECT Customers.CustomerID AS Customers_CustomerID, Orders.CustomerID AS Orders_CustomerID, Customers.Address, Customers.City, Customers.PostalCode, Orders.OrderID, Orders.OrderDate
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE (((Orders.OrderDate) Between #1/1/1996# And #12/31/1997#));



it is probably something simple I am missing here! Sorry to keep asking :(

View 1 Replies View Related

IIf - This Has GOT To Be Simple...

Mar 16, 2007

but I can't seem to figure it out. All I get is Null values when I run the query.

I have a form with a start text box and a end text box. I use the form name sucessfully in the criteria row so I know there is no problem with the form name. I also know there is no problem with the qry name. Does anyone see anything I am doing wrong?!?!

The query I am working in is labeled [qry_old_summary_date_range]. Just wanted to clarify that is not a problem.

1st Pay Increase: IIf([qry_old_summary]![1st Pay Increase]>=[Forms]![Human Resources]![Start] And [qry_old_summary]![1st Pay Increase]<=[Forms]![Human Resources]![End],[qry_old_summary]![1st Pay Increase],Null)

View 1 Replies View Related

This Should Be Simple ...

Mar 30, 2007

and presumably it's only me who's irgorant.

I have a table with dates of deadlines and another with dates of submissions. For each deadline I want to know who submitted first. I figured that all I had to do was compute the difference between the dates and the select the minimum. However, Access rejects the Min() function in the WHERE clause. How do I avoid this?

Thanks a lot !!

View 10 Replies View Related

This Should Be Simple ...

Jun 27, 2007

I have a table (imported from excel) that is a pricing grid for blinds. The header row at the top is widths(mm) and the header row down the left is heights(mm). The data is the price. The import process makes the widths the column names.

height 600 800 1200 ...
300 $60 $80 $100
600 $80 $100 $120
900 $120 $140 $160
.
.
all I want to do is to take that table and make it flattened, like this:

height width price
300 600 $60
300 800 $80
300 1200 $100
600 600 $80
600 800 $100
600 1200 $120
900 600 $120
900 800 $140
900 1200 $160

I can't think how to do this in a query - I could take the flat version and create a crosstab to go the other way. Any clues - I don't want to change too much about the way the imported excel file looks becasue I have no control over that (I already discard miscellaneous heading and junk before I import it)

Hope you can help

View 4 Replies View Related

This Should Be Simple

Jan 15, 2008

My Brain has completely lost all of it's gray matter.

I have two tables tbl_Employers and tbl_Services that are linked via a one to many relationship. Each Employer can have Many Services. The field i am useing in the relationship is EmployerID

If I build a simple select query using these tables I will see all of the employers that have a related record in the services table. Any employer could be listed there many times as per the relationship.

What i want is a simple count of how many employers actually have recieved a service.

Why is this so difficult for me to get my head around.

View 7 Replies View Related

A Simple One! Please Help! :D

Mar 5, 2008

this is my query in design viewhttp://img99.imageshack.us/img99/3095/querytc3.th.gif (http://img99.imageshack.us/my.php?image=querytc3.gif)i use this query when entering datai want to know how i can set it up it display all or any one/two/none of the criteria i put into the question text boxes, number surname and state, or even just number, or just state.anyone?

View 1 Replies View Related

Really Simple One

Mar 12, 2008

this might be a crude roundabout way of doing things
but it works as is, and i'm trying to streamline a little.

i have a database that contains all of my customer's details.
once a month remove those whom no longer want my mailout,
and export the remainder into excel so that my printer can print and stuff envelopes.

i record customers that no longer wish to recieve my mailout, by putting something(anything) in a column that says rts.

what i'm trying to work out is, how in a simple query i can prevent any record that has any value in the rts column from displaying the name/address etc.

if there's a code to say

if anything in rts exists then hide name address state postcode

View 2 Replies View Related

Should Be Simple

Jan 24, 2005

G'Day:

I am working on a simnple form that has just a few simple calculations in it. One being wieght difference and the other being percentage weight difference.

I get Access to calculate the wieght difference easily, but Ican't then get it to calculate a percentage weight difference (in another cell).

This is what I have down for code.

If Weigh1 <> 0 Then
WeightDiff = Weigh1 - Weigh2
End If
If WeightDiff <> 0 Then
PerWeightLoss = WeightDiff / Weigh1
End If

Any Suggestions?

Thanks

View 10 Replies View Related

A Simple One.....

May 15, 2005

:confused: I have a logon form which works well and authenticates users via a table. The problem is when the form is loaded the user has to click into the text box to type their name. I want a cursor to be flashing in the text box when the form opens so the user can type their name straight away without having to touch the mouse. I have ensured that the tab index for the text box is first however this has not resolved. Is it something to do with focus? If so how to I ensure that the text box has focus on launching the logon form??

View 1 Replies View Related







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