Hi, noob in need of assistance..
i want to be able to create three combo boxes that are filled dynamically from my tables but each selection box to be "restrained " by the value fo the previous selection.
for examble
combo1 Categories (display all my categories)ok
combo2 Subcategory( display only subcategories of the previous selected category)
combo3 Subsubcategory2 (display only subcategories...
MadSma
Last Activity: Jul 29 '13, 09:31 AM
Joined: Sep 16 '10
Location:
-
multiple - linked dynamic combo boxes from sql
-
yeah sorry for the crappy code...forgive the newbie pls
resetting the regional setting did it for me
thank you all for your responses there where all very handy first of all i wasn't sure if the codes logic was correct when i learn from you guys that the logic was correct i was looking for the problem elsewhere and NeoPa gave excellent advice
thank you all -
Syntax Error in Query
on the desingh view of my qwery that shows endindDate(end) and description(des c)
i added the following:
so that each time the query runs to autocalculate how many days left from the end date until todayCode:exp1: DateDiff( 'd',Date(),[end])
my problem is that i get invalid syntax erro and it marks my first comma
at first i thought it was the current date naming and i have also tried todaysdate,curD ate... -
open a form at a specific record from a datasheet form
hi i have a formA in datasheet view and i want to be able to click on any fieldZ and to open formX on the specific fieldQ that matches that of the first form(fieldZ)
ie fieldZ is equal to fieldQ
ihave tried an open form onclick macro
where
="[name]=" & [name]
and
="[name]=" & [forms]![formname]![name]
but access will not regognize nothing of the... -
open a form at a specific record from a report
i have a report rptDisplay
and i want to be able to click on a field and the form frmEdit to open on the spesific filed i clicked
any thoughts? -
thank you malcolml that did the trickLeave a comment:
-
thanks for all the help i feel im getting closer to the finish line
i have used malcomk way and while trying to use the query to search within a table based on a form input i cant get it to work
in the criteria of the query i write select.... from....
WHERE (((tblregistry. name) Like [Forms]![searchForm]![txttitle]+'*'));
this works for searches abcXXX but how would i include the XXXabcXXX form
...Leave a comment:
-
just few clarification
when creating the query and entering Like([forms]![table1].[controls]![fname].[value])in the criteria
table1 is the name of my table and in the examble cases should it be clien?
also what should i write in the place of [value]
and a thrid question what is frmcountry did you mean the frmclient?Leave a comment:
-
Date Calculations Based on User Input
hi as i am a newbie to access i need some help for some basic functionality
i need to be able to calculate a date after 6 or 12 months based on a staring date the user inputs on my form as well as an intervaldate of the users choices
ok what do i have
in a form called duration i have
1. a list box [Duration]that holds 2 values(6months and 12 months)
2. a dateField called [starting_date]... -
i just saw that i used Table1 instead of [datasource] but it is not working even when i use [datasource]Leave a comment:
-
thanks alot this is very helpful as to create the search but i think i still have implementation problems
Here is what i did
i exported the form to my db and i then used it to create an sql statement
Select * from [Table1] Where [age] Like "*sage*?" OR [name] Like "*sname*?" OR [team] Like "*steam*?"
where sage,sname and steam are the filed on my searchform
and i used...Leave a comment:
-
hi Mr Key thank you for replying and sorry for that post i wasnt sure i could asked using so many details.
ok here i go again
i have a table containing my data called dataSource
it contains the field ID(primary key),name,age,d ate,team
i also have a form called dataEntry using the form wizard that enable me to enter data into my table(datasourc e)
i also created a report called report1 using the report wizard...Leave a comment:
-
ms access best way to create a search form
hi iam quite new to access and i am now at a stage where i have created my database tables and various forms to input data on them but i need a way of displaying data based on some search criteria
for this i have created a form with various unbound fields but i do now how to proceed.
i also have create a report based on the table i want to display results from that is now just displaying all records
how...
No activity results to display
Leave a comment: