Search results for query: *

hi i have a db (ms-access) that includes tables, relations and data. this db is part of an application in somes clients places, which means that in each place, the data is different. my db has changed, i added tables , even some tables have data that should be passed to the clients db. that...

how can i import existing tables from mdb to vc++ database project??

hi! i have a db that sits on network. this is a multi-user db, where i want to lock access to anyone when someone open it. so i try, according to ms-access help, the "open exclusive" . i set the option "open exclusive" instead of "shared" in menu-> options->...

i have a subform bound. i have a checkbttn in the principal form and i want, if i check it to true, to write date in a field of the subform, for all the records in the subform, for this field. 1. how can it be done? i success to write the date for 1 records, the activate one i think, but i cant...

i want to unlock a label in a form according to the following condition: i have a subform in the specific form with data linked to the form by the index key of the table. in each line of the details form, i have a field "payment date" in the first form i want to unlock field...

i want to unlock a label in a form according to the following condition: i have a subform in the specific form with data linked to the form by the index key of the table. in each line of the details form, i have a field "payment date" in the first form i want to unlock field...

hi! i have a form where i choose according to which fields filter a second form i did: Case 3 stLinkCriteria = "orders.supplier = '" & txtSupplier & "'" the problem is that i want to filter my form per supplier like i did but i want to filter the records where the field...

hi! i have a form where i choose according to which fields filter a second form i did: Case 3 stLinkCriteria = "orders.supplier = '" & txtSupplier & "'" the problem is that i want to filter my form per supplier like i did but i want to filter the records where the field...

but the problem is: i want to combinate year+index as 4 digits and when i do it i lost the the 4 digits: ydate = DatePart("yyyy", date) orderfullID = ydate & "-" & id_order -----> 2002-1 and not 2002-0001 how can i do that ? i tried: orderfullID = ydatee &...

the problem is: i want to combinate year+index as 4 digits and when i do it i lost the the 4 digits: ydate = DatePart("yyyy", date) orderfullID = ydate & "-" & id_order -----> 2002-1 and not 2002-0001 how can i do that ? i tried: orderfullID = ydatee &...

here my question : i build a little application database-oriented. now i have a problem: if the application will be on the network- on all people computers, so how it will be with the database? how can i set the application as locked or something else to avoid 2 people to use it at the same...

hi! i have a unique key in a table that is an index like this : yyyy-9999 this has to year+"-"+number id as 4 digits how can i force the field to be like this?? and how it will be in the forms? how can i add it as automatic number 2003-0001 2003-0002 ... can...

i want to ask for a query: SELECT * FROM order_details INNER JOIN orders ON order_details.id_order=orders.id_order WHERE commitment_date <> &quot;&quot;; i mean where this field is empty why this is not working ??

please help me i'm sure this is not complicate..) i have a form that permits me to select the good option to filter the data. i have a frame with some options for each frame options at the end i have a query that give me the filter when i want to enter the form with the filtered data, i click...

please help me i'm sure this is not complicate..) i have a form that permits me to select the good option to filter the data. i have a frame with some options for each frame options at the end i have a query that give me the filter when i want to enter the form with the filtered data, i click...

i have a condition : If commitdate = null Then ---- --- end if commitdate is really empty label with null value but it is not enter the if statement ! i try If commitdate = &quot;&quot; Then but the result is the same what can i do to check if there is a value in this label??

i have a form that permits to display all the data from 2 tables and i can navigate between records. the data is bound. i want to add a form which will permit me to filter the data and diplay records that interest the user according to simple filters like a field or two. so i thought to write a...

i have a sub-form in a form i want to lock a field in the subform according to a condition from the principal form. i try : If commitdate.Value <> &quot;&quot; Then supply.Locked = True // this works : this field is in the principal form order_details.descr.Locked = True //this...

i want to add a little function to check a field as password for users when opening my application. the password has to be saved in the database for my needs. do someone have a function &quot;ready - to -use &quot; with the check of password and &quot;stars&quot; print instead of the string of...

i have a field date that i saved as short date format in my settings, short date corresponds to mm dd yy i need to change it to dd mm yy when i write it on the form, and save it as dd mm yy too. how can i define that??