Limited Posts In Access DB Forum

May 2, 2007

Hi there!

I`ve been using Access DB for a forum for about two years now, but from time to time I have to download the db and delete about a 1000 posts (+/-).

The reason for this is that the db want accept more posts unless I do so.

My question is how do I "extend" the db to accept more posts?


Thx in advance,
Sarre

View Replies


ADVERTISEMENT

Forms :: Limited Access To Only One Form?

Apr 1, 2014

All, using 2010. I have a database that is split into FE and BE. The FE is on users desktop. The supervisor wants to give limit access to the database to one other user on the network without giving them access to the entire db. There is not an user table in the database or a login form at the moment. So what can I do to provide limited access to only one form?

View 1 Replies View Related

How Do You Put Usernames In Forum In Access? Please Help Me?

May 25, 2006

Hi,
I have been using access for quiet awhile (I learned it 2 months ago). I want to have a online business (using Dreamweaver and Access) but, I want to organize my data and I want to figure out how (when you go onto a website say target.com) to make the username and password in Access (Like when you register for an account, you put in your username, password, email address...ect. and the you make your account and then when you put in you username and password again to log into your account (I want to know how to do that)). Another thing, when the person logs into a account and wants to buy a product how do you do that in access.
Any answers can help me.
You could send me a link to a webpage that tells me how to do this stuff.
Any Tips?:)

View 1 Replies View Related

Access Query Field Limited To 255 Characters

Jan 24, 2007

Hello,

I have created a query using the query builder by concatenationg several fields using the expression builder. Once concatenated, the total number of characters is greater than 255, and is therefore truncated. Since this is a query field and not a table field, there must be a way around this limitation. I can't even create the query and dump the results into a memo field because the dump will still only contain 255 char.

I could probably create the query using VBA, which creates a table containg a memo field, which is then populated by a variable containing the concatenated fields, but I would like a simpler solution.

Any ideas on how I can generate a query field that contains more than 255 char? The query is used to populate a report.

Thanks in advance.

Ken

View 6 Replies View Related

Excel To Access Import Limited To 255 Characters...

Nov 30, 2004

In importing data from Excel 2002 to Access 2000, I have several columns of text data that has more than 255 characters; however, importing into Access does not give me the option to redefine those data fields from "Text" to "Memo". As a result, Access truncates the data to 255 characters.

Is there anyway to work around this issue by still using the Excel file? I have saved the Excel file as an HTML file and this seems to work, but it is an extra step that I would like to avoid.

Thanks for any help.

View 1 Replies View Related

Does Some From The MS Access Group Monitor This Forum?

Mar 10, 2006

Surely I am not the only one who imports text files in to Access (on XP) containing double quote characters???

Does Access quit the import at the double quote character for anyone else.

To the MS Access group.. have you tried this??

Thanks

View 1 Replies View Related

Attention To The Best Access / VB Programmers In This Forum

Feb 9, 2006

Right first of all hi everyone,

i have been to about four forums now and No One has been able to make this work it can be done as i have seen it from the access sample database (Order Entry). I have been informed that this forum has the best of the best in access guru's, this problem has had me stuck for 2 weeks i don't normally asked for help but it has breached my knewledge base and now its time for an expert to have a look at it.

I have had many suggestions but none have worked, below is the link to the Order Entry database so you can see what i am trying to acheive and also another link of my actual database as it stands.

The problem is that i have a form called Customers this is displayed when the database is opened, the form has a subform called QuoteSelector that holds all the quotes if there are no quotes then the user is then able to add a new customer and then create a quote when they click the Create New Quote button.

Then another form called Quotes opens this holds the data form the quote and also has a subform called QuoteBuilder, this form holds all the materials that have been selected for the quote.

Now when i click the Create Invoice button that is on the Customers page i want all the information from these forms to be displayed in my report called Invoice. I have already created the Invoice i am just having trouble in passing the CustomerID and the QuoteID to the Invoice or i think this is what is needed in order to make all the data display.

If you can help this would be great as no other forum has been able to and this one has the best reputation for programmers with access so well i will have to see it, but please take a look at the Order Entry database and see how the Invoice is generated you will notice a box pop up letting the user enter more details i don't want this i just want the invoice to come up and then the user can print it.

Thanks in advance and hope this can be done:

This is the sample database Order Entry

Order Entry Download (http://www.weblogics.co.uk/Order Entry1.zip)

This is the Database I NEED to create the invoice for:

Database FOR Edit (http://www.weblogics.co.uk/quotes.zip)

View 2 Replies View Related

Monthly Width Limited FILE INPUT TO ACCESS DB

Jun 8, 2006

Alright, I'm trying to read and parse a file that'll be outputted monthly by another system that i cannot change (csv would be my prefered choice) so i'll havta deal with what i got. I'm not entirely sure how to go about this, but my intent is to have a form in my database for a user to bring up a open "*.txt" which is a width limited text file. the other system outs puts this file with a header like the following:

Date: 06-08-06 [08:53] recdate4) Receipts by order, position and sequence Page: 1
CFM Production Company Comp: 100

-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
Supplier | Name | Item | Order | Position | Seq. | Receipt | Ordered | Delivered Qty | Del. Date | Rec. Date |
---------+-------------------------------------+------------------+--------+----------+------+---------+---------------+---------------+------------+------------|
100048 | RUSH ELECTRONICS | 53182 | 131810 | 1 | 3 | 204355 | 100000.0000 | 6800.0000 | 02-17-2006 | 01-06-2006
100048 | RUSH ELECTRONICS | 53182 | 131810 | 1 | 4 | 204440 | 100000.0000 | 3755.0000 | 02-17-2006 | 01-09-2006
100088 | MILLOMAT STAMPINGS | 10000893 | 132183 | 2 | 1 | 206065 | 19.0000 | 19.0000 | 05-11-2005 | 02-08-2006
100148 | PROSCIENCE INC | 10006712 | 132711 | 2 | 1 | 204083 | 135.0000 | 135.0000 | 01-03-2006 | 01-04-2006
182708 | RELIZON | 10008087 | 133187 | 2 | 1 | 204202 | 1000.0000 | 1000.0000 | 06-02-2005 | 01-04-2006
199402 | MIC INDUSTRIAL LTD | 06508 | 133996 | 1 | 1 | 205056 | 2304.0000 | 2304.0000 | 01-10-2006 | 01-20-2006
100088 | MILLOMAT STAMPINGS | 10007738 | 134398 | 9 | 1 | 205862 | 63.0000 | 63.0000 | 09-02-2005 | 02-06-2006
100032 | SPECIALTY GASKETS INC. | 10008184 | 134525 | 1 | 1 | 205812 | 150.0000 | 120.0000 | 04-25-2006 | 02-03-2006
100032 | SPECIALTY GASKETS INC. | 10008184 | 134525 | 1 | 2 | 207516 | 150.0000 | 30.0000 | 04-25-2006 | 03-07-2006
100032 | SPECIALTY GASKETS INC. | 10008184 | 134525 | 2 | 1 | 208138 | 120.0000 | 120.0000 | 03-17-2006 | 03-16-2006
199309 | BARZELLE | C0C3301 | 134707 | 1 | 9 | 207121 | 572.0000 | 40.0000 | 11-21-2005 | 02-28-2006
199309 | BARZELLE | C0C3301 | 134707 | 1 | 10 | 207253 | 572.0000 | 23.0000 | 11-21-2005 | 03-02-2006
199309 | BARZELLE | VE2333 | 134707 | 7 | 1 | 205893 | -15.0000 | -15.0000 | 11-08-2005 | 02-06-2006
100103 | DON PARK INCORP | 50986 | 134820 | 2 | 1 | 204551 | 30.0000 | 30.0000 | 09-29-2005 | 01-11-2006
100103 | DON PARK INCORP | 50987 | 134820 | 3 | 1 | 204551 | 30.0000 | 30.0000 | 09-29-2005 | 01-11-2006


Sorry about the ugly post of the outputted file, but it is width limited by 255 characters and has verticle bars and spaces sepearating the fields i want. I want to ignore the headings. in addition the column titles since i will already know where they're going to go (hard coding it). can someone explain how to parse line by line as a new record in access db?

- defy

View 4 Replies View Related

Modules & VBA :: How To Give User Limited Time Access To Certain Forms

Aug 26, 2013

I have database that i am working on , i want to give a user a time limited accsess ( one week ) to the reports section for example !!

after a certain date he will require a password or the report button will be inactive ...

-at program start up , it will check for today's date if it is greater or equal to (lets say ) 24-9-2013 then it will change a field in an X table from "yes" to "no" ,

-after that the code will check table X for the yes no field , if yes then open Form A if no then open form B / or make report button inactive

how to do that in VB ... and is there is a better way to do it ? can it be done in the macro builder ?

View 4 Replies View Related

92, 000 Posts??? But I Am Only New

Sep 15, 2005

Can anyone tell me why I have 92,000 posts when I have only just joind today?
I am fast but not that fast.....

View 14 Replies View Related

Old Posts

Jun 5, 2005

I'm really afraid to ask this question. I was working on a database for our LawFirm about a year ago but it was a longterm project and low priority. For reasons beyond my control I got away from it and am just getting to back to it. Miles and many of you were very helpful to me in answering my questions. I can't remember the user name I chose and my dob is not listed so I can't find it that way. I have searched what I thought was the user name and every combination thereof. I'm wondering if I got deleted after so long for inactivity? I certainly don't to waste people's time by asking the same questions a second time. Anyone have any ideas how I can find my old posts?

View 2 Replies View Related

Duplicate Posts

Jul 11, 2005

i have a table with 3 fields: ID, line_item, and pay_app.

line_item and pay_app are linked to other tables in a one-to-many.

For every pay_app, there can be up to 100 line_items. However, I only want each line item to appear once (at most) in each pay_app. I want to prevent the same line item from showing up multiple times in the same pay_app. Essentially, I want to prevent duplicate entries, but with a stipulation, if that makes sense.

View 1 Replies View Related

How Do I Find My Posts?

Sep 27, 2005

I realize this probably isn't the right place for this, but...how do I find all of my posts, whether I started a new post or responded to someone else's post?

Thanks in advance to whoever replies :D

View 2 Replies View Related

Finding My Posts

Sep 4, 2006

Is there a way to find all my old posts except looking at all 381 pages?

View 4 Replies View Related

Adding Links To Posts

Feb 28, 2008

Sorry, cant find this in help, and cant do it by trial and error

How do I add a link to a post/thread in a reply

View 4 Replies View Related

Security Question..after Reading Many Posts..

Jun 16, 2005

I didnt find answer to my question!..
Hope someone here can help..

I just added security to my access application...
I have added a new user and gave all admin rights. Removed all permissions from Admin and Admins group. When I log on as this new user who is equivalent of Admin,

I am able to doubleclick the table(linked table) and modify/delete the data..but when I the form is executing, it says, "Records cannot be read, no read permission on <Table>"

Hope someone can answer my question.

Thanks very much.

View 1 Replies View Related

Congrats To Rural Guy - 2000 Posts

Jan 3, 2006

Congratulations on your 2000th post since July 2005.

That is indeed impressive.

Best wishes,

Bob

View 3 Replies View Related

General :: Not Receiving Email Notifications Of Posts

Apr 9, 2013

I don't appear to be getting any email notifications of posts in threads to which I have subscribed.I have Instant in my profile/userCP, but have not been receiving emails for some time. I edited my preferences today again -- I set it to daily, saved, then reset to instant, and saved. Thought that the edit may tweak some anomaly???

View 3 Replies View Related

Limited Incrementation

Mar 30, 2006

Hi I am a noob and I'm having problems performing a particuler form.

I need a form that will auto-increment records as they are ented from 1 to 20 but once I have receached 20 I need it to start over at 1. So no record will have a higher number than 20 in this particular field.

Any help would be greatly apprciated.

:)

View 1 Replies View Related

New To This Forum

Mar 9, 2007

Hi,

Before I ask my question I was wondering if it was possible to attach a zip file of the database I'm working on? It would save some typing.

Thanks

Eddie.

View 2 Replies View Related

Selecting Limited Rows

Oct 13, 2005

I have a table containing items and their prices. I need to run a SELECT Query which can return the last 5 prices for each item.

My Query is:
SELECT item, podate, price
FROM PurchaseOrders
GROUP BY item, podate, price
ORDER BY item, podate DESC, price

Let's say my Item A001 returned 12 records. I need only the 1st 5 records in my Report.

Can anybody help pls???????????

View 2 Replies View Related

Limited Records Past Date

Jan 3, 2007

I have a query that returns a set of records which details stock items that are older than a date given in a form. However i need to limit the results to the number of items held in stock
i.e say i want to look at stock over 1 year old, i get a list of all the stockids, and the date added.
Say there is a stock level of 3 for a particular stockid the results should be limited to the first 3 records that are over 1 year old. Rather than the whole list of dates I get now.

Any help or direction with searching terms would be appreciated

thanks:confused:

View 2 Replies View Related

Hello I'm New To This Forum And I Have A Question :)

May 16, 2005

Several of my databases is a little slow and that puzzles me since there isn't over 200mb of data yet :confused:

Is there any advantage in storing data on an oracle server and will it speed up things or is there other things I can do?

Perhaps someone in here would be so kind to look at my database and give some advice on the structure and possible changes to improve performance?

Perhaps I should add that I don't know much about other database tools so I'm shooting in blind here.

So if anybody will look at my database and see if he/she can optimize it I will be happy. I can leave little data inside to allow You to see the output - if needed.

I'm not very technical with access (not yet) so things might be done differently than I do to speed up things

Any help is greatly appreciated :)

View 4 Replies View Related

Forum Restructure

Mar 19, 2007

Due to the ongoing bulk of regular spam posts that this forum receives, and based on similar activity on other forums, I think it would seem to be that the reason for this is the use of the word 'General' in the forum's title. In my experience it is the areas marked this way that generate the most spam, be it 'General Discussion' or otherwise.

So, in order to try and combat this, I was thinking that it may be in the forum's interests to change the name of this section. If it's what spambots are geared up to search for then it makes sense to shield the target from them.

My thinking is that, were I to change the name, the forum would be best placed at the base of the 'Microsoft Access Discussion' area and renamed to 'Other Issues'.

Thus, my plan would be to have the 'Microsoft Access Forum' ordered in this way:


Database Design
Tables
Queries
Forms
Reports
Macros
Modules
Other Issues


I'd appreciate others thoughts on this so reply away. There's a poll at the top of this thread if you just want to post a yes/know/don't know sort of response. The poll will only be active for one week, starting now.

View 14 Replies View Related

This Forum Got Me In Trouble...

May 1, 2007

Hello all active members of this forum,

Like I stated on the title, this forum got me into trouble. By following the reading in this forum and some recommendations from the regular users I have created thre database for the place I work at. now they want me to be the official DB admin! :eek:

So now I'm coming back to you guys for more advice... :rolleyes: what reading should I do to better my Access knowledge over all.

Any recommendation is welcome.

I have already contacted th local college and they do have a distant learning class for Access and I will be taking it the next semester, but I would like to do some reading into becoming a REAL Access programmer with a solid foundation.

There must be some good books out there to purchase to get me started. So all are welcome to give me some feedback.

Thanks!

René

View 14 Replies View Related

Forum Database

Jan 2, 2006

I have been tasked to design a Forum Database using ASP, could someone please point me in the right direction as to the design for table structure for this.

I know that the user will be looking at a web front end which in turn will be accessing the Access Database.

Any assistance would be much appreciated.

Dispersion36

View 1 Replies View Related







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