Go Back   Access World Forums > Search Forums

 
Showing results 1 to 21 of 21
Search took 0.03 seconds.
Search: Posts Made By: Elie00
Forum: Forms 10-25-2018, 06:12 AM
Replies: 3
Views: 650
Posted By Elie00
Forum: Forms 10-25-2018, 04:56 AM
Replies: 3
Views: 650
Posted By Elie00
Unhappy Button for adding a record in a different table (after update)

Hey everyone!

I tried looking for the solution from within previous posts but couldn't find any! so i'm sorry if this might be a double post from someone else.

Anyways my issue is as follows:...
Forum: Tables 10-04-2018, 10:45 PM
Replies: 4
Views: 282
Posted By Elie00
Re: Lookup wizard on a formatted primary key

Thank you guys! i formatted it in the forms to appear as i want it to and kept numerical in the tables.
It's always the simplest solution that works the best!
Forum: Tables 09-28-2018, 04:24 AM
Replies: 4
Views: 282
Posted By Elie00
Lookup wizard on a formatted primary key

Hey guys,

So i have two tables, one being child to the other, first one is called "jobs" with a formatted primary key being job-0001, job-0002 etc...
The second table is "quotation" table, it...
Forum: Queries 09-24-2018, 01:35 AM
Replies: 4
Views: 788
Posted By Elie00
Re: appending a single entry

Hey Minty,

I do not wish to duplicate the entire data set, just the ones that were accepted.
I want them separate and accepted quotes to be moved to the table "Jobs" since there will be another...
Forum: Queries 09-24-2018, 12:39 AM
Replies: 4
Views: 788
Posted By Elie00
appending a single entry

Hello everyone,

The database i'm creating is for my sent and received quotations sent (me being the middle man).

I created all the tables and forms I need for this, I would like to add an...
Forum: Queries 10-24-2016, 01:31 AM
Replies: 5
Views: 338
Posted By Elie00
Re: Query with parameter not always working

Hey Minty,

sorry i took too long to reply but i had put that project on hold.
Anyways I solved the issue by deleting the automatic ID key field and kept the port names and it works fine now!
...
Forum: Queries 10-12-2016, 03:29 AM
Replies: 5
Views: 338
Posted By Elie00
Re: Query with parameter not always working

So i'll have to input the port names one by one in the lookup field? even if i have hundred or names??

Any other way?
Forum: Queries 10-12-2016, 03:17 AM
Replies: 5
Views: 338
Posted By Elie00
Query with parameter not always working

Hey guys,

I have a table called "Jobs" with different fields, most are picked from list. Some lists are look up field from an another table for example "port list" and other were typed directly "I...
Forum: Queries 05-20-2016, 01:08 AM
Replies: 9
Views: 1,371
Posted By Elie00
Re: Query for a button opening a sub-table form

Thx Minty I was doing it all wrong, it's working now. i created the forms independently and adding them on each tab.

Thanks again.
Forum: Queries 05-19-2016, 04:16 AM
Replies: 9
Views: 1,371
Posted By Elie00
Re: Query for a button opening a sub-table form

i'm having an issue with tabbed forms....

everything works fine when i insert the fields of the first tab, but when i insert the fields on the second tab and test the form, the whole things...
Forum: Queries 05-17-2016, 03:19 AM
Replies: 9
Views: 1,371
Posted By Elie00
Forum: Queries 05-17-2016, 03:15 AM
Replies: 9
Views: 1,371
Posted By Elie00
Re: Query for a button opening a sub-table form

Hello Isskint,

the three sub-tables have a one to many relationship with the main table "Jobs"
the first one is called "ex-works", second is called "freight rate" and the third is called "customs...
Forum: Queries 05-17-2016, 02:50 AM
Replies: 9
Views: 1,371
Posted By Elie00
Query for a button opening a sub-table form

Hey guys,

I want to create a button when pressed would take me to a form showing the details of the sub-table of the entry currently on screen. i'm sure it's a query.

For example:
I have a...
Forum: Queries 08-01-2012, 01:43 AM
Replies: 2
Views: 725
Posted By Elie00
Re: Adding a single record to another table with auto number

i'm bound to have a printing auto number, cause it has to be in a certain format.

actually i don't need a "creation" auto number, i can input it manually.

i can always use the initial table...
Forum: Queries 08-01-2012, 01:24 AM
Replies: 2
Views: 725
Posted By Elie00
Adding a single record to another table with auto number

Hello,

Here's my case: i have to issue a document that has 2 auto numbers:
One upon creation of the file and the other upon printing.

My initial idea was to create 2 tables, the first...
Forum: Reports 04-11-2009, 11:11 PM
Replies: 3
Views: 1,122
Posted By Elie00
Re: Labels from 2 linked tables

thx for the reply ajetrumpet
i didn't understand ur first question u mean saving them? or
no it's not a title for a report, i want to print them on stickers for envelops,

here's the structure...
Forum: Excel 04-11-2009, 08:49 AM
Replies: 8
Views: 1,581
Posted By Elie00
Re: IF Statements

is there a certain number of IF statement i can't go beyond in a single cell?
i was trying to create multiple IF statement in a single cell but was stoped at the 7th IF due to an error in the...
Forum: Reports 04-11-2009, 08:36 AM
Replies: 3
Views: 1,122
Posted By Elie00
Labels from 2 linked tables

hey

i'm trying to create a label for a mailing list using 2 tables, the first contains the name of the company, address, phone number, and the second table contains the name of the ppl working...
Forum: Forms 07-08-2008, 04:00 AM
Replies: 11
Views: 1,321
Posted By Elie00
Did u try the "link tables" option in the file...

Did u try the "link tables" option in the file menu?

File>Get External Data>Link tables

whenever u fill the tables in access they will be added to the excel file

hope this helps
Forum: Forms 07-08-2008, 03:24 AM
Replies: 0
Views: 895
Posted By Elie00
Arrow comboBox

hey

i've been trying to create a subform for an invoice i.e. invoice details

Action needed:
i select the name of the product from a combobox and it's price and description appear in their...
Showing results 1 to 21 of 21

 
Forum Jump



All times are GMT -8. The time now is 06:09 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World