Search results

Hi everyone, I wrote some VBA Codes but I become errors. :banghead: Private Sub btnAdd_Click() If Me.txtMail.Tag & "" = "" Then CurrentDb.Execute "INSERT INTO tblEmployees([E-Mail], [Name], [Surname], [Title], [City], [Phone_Number]) VALUES ('" & Me.txtMail & "', '" &...

Hello Everyone, I have several questions. I was not sure, which sub forum shall i use, that's why I'm writing in General. I created new DB,(this DB is for our IT-Equipment) and also tables and relationships. I have also Forms. My main Form name is "Personal_Info". This Form has also 4 (5...

Hello My Friends, I have 2 Type of Fields. First one is : "ProjectNumber" other one is : "ProjectGroups". I will write here sort : "ProjectNumber" as a PNr. "ProjectGroups" as a PGr. What do I need : (I really do not know how can i explain my wish basically.:confused:) At Pictures as you...

Hello my friends; I made a "Stacked Column Chart" and there is 5 different Axises. When I was creating my query, first of all built a new table. Because I do not want to see Axis as an alphabetically. On my query it is working perfectly. But when I create new Chart, Access is sorting...

Hello My friends, If you check to Picture i have 3 Records. i have 2 questions here : 1- How can i show on screen Bus > Budget Total with text box ? 2- Please IGNORE Total and how can i sum For example Truck Budget AA + Budget BB shall i write for every 3 records different Query or is...

Hello My Friends, I wrote so basic a macro and bound up with a Button. Im exporting Excel Sheet from my companies Program and importing to Access. Everything is functioning automatically. But when I try to import Excel Sheet Im getting run time error 3709. :banghead: I checked Import Error...

Hello My friends, i checked from Forum and found many Thread about this Problem. May be i could not understand good but unfortunately i did not find my answer.... Normally this code is working. But it´s too complex because my code is getting bigger and bigger. May be you can find any...

hello my friends, i have a query and there is ID Groups and Milestone. I need to somehow compare them. (please Check the picture.) On this example i have 2 different ID (1 and 2) and these IDs have many Groups. PS: Milestone : C > B > A i need to compare with same ID Data Records but...

Hello friends, Hope so you can help me as soon as possible. Please Check my picture : You can see there same ID number they all same. Those ID's have Groups (A) at this picture only 3 different groups 20 30 40. Actual Date and Appointed Date. (Others not important now.) I need to compare...

Hello friends, I know my title is looking so complex, actually i could not find right words. Anyway : in my query i built a mathematics operation : Result MTB: [T1_alle_Details_pro_Änderung]![FET]+([T81_ursprüngliche Termine Datensaetze identifizieren]![ursprünglicher Ziel...

Hello my friends this is my 2. graphic problem. As you can see at picture. normally i need to see the lines like this. (i painted the blue color) but access shows to me without lines. if the value is 0 (u can see 2. graphic better) the line does not continue. how can i fix that problem ...

Hello my friends, is there any option to fix this problem ?? (u can see at the Picture. ) ty for your helps

Hello If you check my picture, some Records are similar and i need to filter them. (this is a query by the way.) For example 3303933 these are 3 records, i want to see only one (Dates and other thing are not important. I tried TOTAL option but could not find any thing there. Hope so you...

Hello I want to hide on my report unchecked checkbox ? How can i do that ? If i shall write a code, in which event ?? Or can i use in Query Build option ? I searched on internet and found some answers but they are not useful (i found this code and updated for my report but still did not...

Hello Friends; I created a build in Query. The problem is, i need to define many things. For example : Name: IIF([Table_name]![Field_name]="Dog";"Animal"...

Hello friends i have a simple question i could not find any solution:( this is my code : (im using 2007-2010 and its working like that) =Dsum("*";"Table Name";"[Field Name] < 0") i need to calculate only bigger than 0 or smaller than 0 doesnt matter.. i checked from Forum etc. there is...

Hello friends; Im trying to get sum "+" and "-" Values in same Field. I created new Expression Builder in Query and i wrote there : A: Sum([tablename]<0) of course it did not work. :D how shall i update my expression to work this thing ? Ty for your helps.

Hello Friends, As you can see at picture, in my report i want to crate a chart and i want to chance the position of my Properties... It shall come firstly "Perfect" then "Good" and at last "Terrible" how can i do that... im triyng around 2 or 3 hours but did not find any solution :(

Hello Friends, In same field Im saving every time 6 digits data and i need to separate them. (It was not my fault. They created DB like this... :banghead:) For example my data is 123412(main-field) and i want to see them 1234(field1) 12(field2) hope so u can help to me. Ty for your helps

Hello Friends, Firstly i was not sure which forum Topic should i use. If i did that wrong. Im sorry about that. Question is : I have a Field-A and inside some data as usual. My data name is for example "Cow" and "Horse" but i wanna see them in Field-B "Animal", again by Field-A "Mark" and...