General :: How To Show Table In A Post

Aug 12, 2014

I've done a YouTube Video, showing 3 different methods of posting your table structure to a forum HERE:- MS Access - Copy Table Structure for Forum

Here is a Google Doc showing the first procedure of the three:- MS Access - Copy Table Structure for Forum (First Method)

Here is a Google Doc showing the Second procedure of the three:- MS Access - Copy Table Values for Forum

Here is a Google Doc showing the Third procedure of the three:- MS Access - Copy Advanced Table Structure for Forum

View Replies


ADVERTISEMENT

General :: How To Reference A Specific Post In URL

Aug 26, 2014

I have tried to reference a specific post within a thread in response to a question. I have not been successful.

For example: What do I need to go directly to post #17 in this thread [URL] ....

I can get to page 2 using &page=2, but haven't sorted the post number.

View 3 Replies View Related

Copy Table Post And Secondary Table

Jun 26, 2007

I have a problem... I have four tables(but my problem is limited to just two)
The tables are Orders, Customers, Items and OrderedItems
The two more detailed below creates the problem when trying to copy an already existing order to a new since the customers usally order the samethings over and over again.

Orders
IDOrders
IDCustomers
strSalesperson
strWhen
strSent

OrderedItems
IDOrderedItems
IDOrders
IDItems
iNumber
bPacked

So I have made a copy button on the order form. The copy button should do this:
1. First save the old orders IDOrders and IDCustomers (which it does)
2. Create a new order with old data (which doesnt do)
3. Copy all post in OrderedItems with a new IDOrdered using INSERT INTO and using columns

My SQL statement is like follows:
sSQL ="INSERT INTO Orders(IDCustomers, strSalesperson, strWhen, strSent, strComment) VALUES (" & itmpIDCustomers & ",'" & strSalesperson & "', '" & strWhen & "','" & strSent & "');"
But the reply I got is "Could not find output table 'Orders'" but I have checked the names over and over again but it doesnt work.

View 1 Replies View Related

General :: Combo Box To Show Name For User But Input ID To Tag Table

Jul 14, 2013

I have a AUCTION form, it has a combo box and the label for this combo box is called seller. This combo box is a look up to the USER table which has the following fields:

uid, uname, city, state

The combo box is pulling and displaying a drop down list of uname from the USER table, with this SQL state in the "row source".

Code:
SELECT user.uname FROM [user] ORDER BY user.uname;

In the control source of this combo box I have seller, and the form's record source is AUCTION, tagging on the AUCTION table.

The problem is the form is putting the uname into the AUCTION table's seller field, but I want it to input the uid field, however that it should still show the uname list when the user click on the combo box to make a selection.

View 2 Replies View Related

Kinda Like Recent Post Macro Updates Table

Aug 13, 2007

ok i have this query.
Code:UPDATE [Claims Header] SET [Claims Header].status = 'I'WHERE ((([Claims Header].Claim_ID)=[claim id]));WHERE ((([Claims Header].Claim_ID)=[claim id]));
i want to have a button that runs this query but how do i pass over the claimid from my form? also when it's done running the query i want it to run a report.
so i was trying to make a macro, but how do i tell the macro to find the claim id from the form?

View 1 Replies View Related

General :: Create New Table By Item ID To Show Balance Of Stock

Feb 17, 2014

I have created 3 tables for simple inventory.

a) Item details
b) stock in
c) stock out

All I simply want to do is create a new table by item id to show balance of stock.

View 2 Replies View Related

Where Should I Post?

May 6, 2005

I have a very involved question regarding the export of data from and Access front end, SQL back end into multiple Excel Worksheets.

Where is the best place to post this in order to get maximum exposure to the great minds that cruise this board.

Regards

View 2 Replies View Related

Not Sure Where To Post This

May 17, 2005

I have a form that has several multiple choice question and i have also designed a table and update queries for the DB so far i can enter the values and then have them changed from the original to the values requested by my bos however i also need to find a way to make a report that will allow me to shot the percentage of people that chose each individual answer with anywhere from 2 to 10 possible choices on each question i see no logical way to do this....... help!

View 1 Replies View Related

My First Post

May 24, 2005

Hello every one
I am new here and this is my first post
I am trying to make overtime record for my company
I use the following feilds

field name .................... format
Start_Time ................... short time
End_Time ..................... short time
Total_Over_Time ........... short time

now when i use
Total_Over_Time = [End_Time]-[Start_Time]
I got correct answer

but

while i am trying to make monthly report
if Total_Over_Time is greater then 24 hours it shows me 1

means for 25 hours is shows 1

Please help me to overcome this problem

Thanks


Pehalwan

View 5 Replies View Related

Don't Know Where To Post This

Jul 8, 2006

I am developing an Access (2000) database to provide reporting data gathered from SAP and make it easily accessable for 12 analysts. The data set is HUGE, 5 months nearly a gig and will need at least 2 years worth, so I don't see any option other than using SQL as a back end. I have experiance using SQL server as the back end but have never had to develop my own server.

I do not have access to an existing server but do have permission to purchase SQL software, this is where I need the help. If anyone has suggestions, advice, links or other information I would be greatly appreciative.

Thanks in advance for your help.

“where I added information”

A lot of you have been reading this but no help.:eek: Did I use a poor title? I have used SQL as a back end but really need to know how to produce one out of thin air.

I ordered SQL 2005 off my company's IT store but when reading further it needs a special operating system, I think. Is this true? What do I need to have in order to provide a very large data set to a bunch of barely computer literate analysts?

These people are excited when they realize that vlookup can do more than one thing!! The concept of a union query would blow them away. I am frustrated with the competency of my co-workers but need to give them something that is idiot proof without letting them know that this is the object.

Currently they are having an SAP download sent to a specified share drive and running an Excel “macro”, moves a couple of columns an such, that puts it into a format that is semi-usable. This is totally inefficient for their needs but they don’t know it as yet.

What I am asking is how to take a fairly robust pc and make it a SQL server that will service a dozen or so people. What kind of operating system is needed and what sort of admin rights will be necessary to allow access to the desktop so they can get their data?

The IT help desk is very scary, not really understanding the requests presented. I haven’t been with the company very long but what I have garnered disturbs me I don’t believe the IT people have a clue.

I’ve been an Access developer for about 4 years now and know this is not an insurmountable obstacle. I am confident that SQL is the solution but haven’t ever had to create it from scratch before. Please, links or other suggestions are MOST appreciated.

View 1 Replies View Related

General :: Don't Show 0 Value In A Report

Dec 16, 2013

I have a report that I had set to not show 0 value when it was a number field. I have now changed the field to a text field (don't ask) but I need it still not to show thw value if it is 0. How do you do that?

View 3 Replies View Related

Dunno Where To Post This....

Sep 4, 2007

Preface: I don't know where to post this since I'm using a VBA executed SQL command or if this is a table issue.

I'm trying to import a .csv file into a "master" table of several .csv files. I've figured out how to link them and import them even though they have different field names, but the problem I'm running into is with serial numbers.

Some serial numbers are entirely numbers, while others are alphanumeric. When the field is set to numbers all of the parts (a different field) show up, but not all of the serial numbers are imported. When the field is set to text some of the parts are dropped, along with their associated serial numbers and then some of the serial numbers show up as scientific notation.

Any ideas on how to solve this problem?

View 2 Replies View Related

Does Anyone Know How To Post A Db On This Forum

Mar 17, 2005

could anyone please tell me how to post a database on this forum ive tried attachingit but it says file not suitable

View 4 Replies View Related

Database Example. Please Post

Nov 10, 2005

i need dbase example from all of u..especially example for newbie like me...i'm looking for example that update subform using combobox...

View 5 Replies View Related

General :: Yes / No Field To Show All Records

Oct 25, 2012

I have txt input [txt choice] which has a number (1-9) and then a query which uses the following formula to define which records are visible linked to a Yes/No field

Code:
=IIf([Forms]![frm selection]![txt choice]="4",Yes,Yes or No)

If the choice is "4" then it works fine, but if the choice is anything but 4 it still shows only the Yes items. If i change the code to

Code:
=IIf([Forms]![frm selection]![txt choice]="4",Yes,No)

Then it does show just the 'No' items but i want it to show 'everything' if the choice is not 4

View 2 Replies View Related

General :: How To Get Day Of Week To Show Up On Form

Aug 29, 2014

How do I get the day of the week to show up on form? when I set the default in the table, I want it to read Fri. 8/29/14 not just (8/29/14) or what ever day that field has focus.

View 1 Replies View Related

General :: Having Column Only Show Up Once In Query

Jun 10, 2015

I just started my internship a couple weeks ago so I am still relatively new, but here's my problem...I have created a query to run the weekly statistics for my data but one column continues to show multiple times. I want the "Left in Estock" and "Left in Estock Line Items" to only show once, instead of all the way down the side. Check out the attachments.

View 11 Replies View Related

Post Code Search

Aug 16, 2005

does anyone know if it is possible to add a post code checker/search to access, if so do you know of one which works. I want to be able to bring up an addess by post code/house number in the UK

View 2 Replies View Related

Validating A Post Code

Nov 29, 2006

HiBeen trying To Find A Way Of Validating A Postcode.But Getting No Where Being They Can Be Like CT1 1QX, CT11 2DT, CT11 12DT Act.Best I've done is to make sure there's a space and it starts and ends with a Letter.Any Help Advice Would be much AppreciatedMick

View 2 Replies View Related

Difference Between Post And Thread

Mar 15, 2007

Hi guys am not sure if i got dis in d correct forum (forgive me if not)

Just wanted 2 know what's d diff btwn a thread & a post (if d's any)

Noks

View 6 Replies View Related

Post-code On Form

Jan 23, 2008

Hallo,

I have a post code field on my form. What I want to do is, if a user enters a wrong code ... i,.e., not Post code format it alerts the user of post-code not in use. Please if there is any example of a database of this functionality usage or a way of doing it will be much appreciated.

I live in UK and the post codes down here are like E12 5AH ....

Many thanks

View 1 Replies View Related

Follow-Up To Previous Post...

Nov 15, 2004

Greetings,

I am just posting a follow-up on my previous post on designing functional forms. Telling by the lack of replies, my original question may have been long winded and tedious. Let me try to narrow my question and make it more concise.

In two tables connected by a one-one field name ProfileID, how can I set a new field in the second table (call it StepNo or procedureNo) so that it increments step numbers for each unique ProfileID record? Thus for each new Profile record created in the first table, a new form will allow the entry of X numbers of steps into the second table and automatically link the two records?

I hope that clarifies my problem. Thanks in advance.

View 3 Replies View Related

Post Code Validation

Apr 7, 2006

I have searched the forum for posts on the subject of UK postal code validation and found the reg expression that seems to be recommended for this.

I tried the expression but it will not accept this postal code? TS183AM

Like "(?:(?:A[BL]|B[ABDHLNRST]?|" & "C[ABFHMORTVW]|D[ADEGHLNTY]|E[CHNX]?|F[KY]|G[LUY]?|" & "H[ADGPRSUX]|I[GMPV]|JE|K[ATWY]|L[ADELNSU]?|M[EKL]?|" & "N[EGNPRW]?|O[LX]|P[AEHLOR]|R[GHM]|S[AEGKLMNOPRSTWY]?|" & "T[ADFNQRSW]|UB|W[ACDFNRSV]?|YO|ZE)" & "d(?:d|[A-Z])? d[A-Z]{2})"

View 14 Replies View Related

First Number In A Post Code

May 23, 2007

Hi,

I'm trying to isolate the first letter / letters of UK post codes.

Typically they are of the format ..

WS9 0JL

The obvious choice is left,2 but of course it's never that simple

some post codes are B1 7FH so left 2 gives me B1 but I need just the B

I can use Left 2 and the look at the second character to see if it is = "1" or "2" etc. but this seems a bit crude.

Is there a way I can find the position of the first number in a string (using the Instr function maybe)

That way i could Isolate the letter/s


Thanks


SBM

View 2 Replies View Related

Form Designs (Please Post Yours)

Jan 4, 2007

One thing that I personally think I'm bad doing is creating GUIs. I think my forms look pretty bad overall, and I'd like to get some ideas/pointers from some of the more experienced folks.

I've included a typical example.

View 1 Replies View Related

Post Code Validation

Mar 20, 2006

hello all
this thing is really bugging me im trying to come up with a post code validation and i have tried dozens, which should have worked really, but just havent so wondering if you guys knew any
examples of postcodes would be

BN3 8JH
BN41 8JH

the first and second characters have to be a letters
the 3rd has to be a number
the 4th is sometimes a letter (not always present)
then theres a space
then there has to be a number
letter
letter

any suggestive codes would be great, as none of mine have worked its in access

thanks

View 6 Replies View Related







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