Search results for query: *

hi no i dont think that replicate the database can help me... in matter of fact i dont have the clients databses and i cant do the upgrade by myself, i dont know even how much data they have in their local database and i cant do the upgrade by replication. i need a program that i will run at...

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 try it but it seems to be an unknown word : CDblFormat what can it be?

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...

thanks! you got a star!!

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 &...

this works, actually! but the little thing left is that i get this following result": 2002-1 2002-2 ... how can i set the number to be -0001 ?? in your sentence : strMyID = DatePart("yyyy",[OrderDate]) & "_" & str(LastID)) it works omly if i delete the str before...

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...

can i ask for another little thing? Dim stDocName As String Dim stLinkCriteria As String Select Case framFilter Case 1 stLinkCriteria = "" Case 2 stLinkCriteria = "orders.id_order = " & txtID & "" Case 3 stLinkCriteria =...

can i ask for another little thing? i see, RickSpr that you are an expert!! Dim stDocName As String Dim stLinkCriteria As String Select Case framFilter Case 1 stLinkCriteria = "" Case 2 stLinkCriteria = "orders.id_order = " & txtID & "&quot...

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...