Search results

i need to create a query to find the balance of creditors with specific dates example 1/1/17 up to 31/1/17 customer A 1/1/17 €20 2/1/17 €25 31/1/17 €25 01/02/17 €100 what was the balance till 31/01/2017 of customer A? using offce 2016

Trying to update table "items" bases on the contents of table "temporaryitems" what i need to do i to go and check if first record on my subform called "temporaryitemsqrysub1" already exists then go and update in table "items" but if does not then go and add it in table "items", then got to...

i have a currency control where the value is "0.00". what is the if statement used to check if it's "0.00" to popup up a window. i tried this code but nothing happens If ITEMSQRYSALESSUB!PRICE1 = 0 Then DoCmd.OpenForm "ZEROPRICEPOPUP" Else:........ thanks

Trying to open a table find specific record and change the stock but i can not get it to work table: items controlS: itemcode and stock field in main form "itemcodesearch" here is the code i use: Dim rstITEMS As Recordset Set rstITEMS = CurrentDb.OpenRecordset(Name:="ITEMS"...

i have this code in the ontimer event of my form. it is supposed to play the next song (from the listbox) after windows media finish current song. i want to add code so that when the current song playing is the last from my list box to go to the begining of the listbox and play agian. using...

i have a form where i need to display the first 6 results (images). the information is comming from a subform which has all the information. also i need to know after pressing the "next" button how to display the next 6 images from the same subform and so on. using ms access 2013

i've got these expressions in a query to extract parts of an mp3 file full path from a field and just let the name of the song. exp: Mid([imported];[exp3]-[exp2];Len([imported])) exp2: InStr([imported];"\")-4 exp3: InStrRev([imported];"\") exp4: Left([exp];Len([exp])-4) "exp4" is the clean...

I have two text fields: their names are : field 1 ="txtfilter" and field 2: "text333" how can i change the names of the two fields with vba code? i need field 1 to get the name of field 2 and field 2 to get the name of field 1 this will be temporarily. using access 2013

i'm trying to build a sellect query to remove part of a text field named "imported" the original text field contains the following " c:\jukebox\REM\LOSSING MY RELIGION.MP3" how can create the expression in my query to remove the part with the path and leave just the "lossing my religion" the...

[forms]![shop touch screen].txtfilter = [reports]!report titles].singer I have this command which copies the contents of a field in a report to a field in a form which is acting as a filter and to requery. (from within the report) My problem is that I don’t know how to apply the call command...

i have a project where i have to create o jukebox. in my sample i have two lists. one is the list with all my records. the other one is the list where they user will choose to play i need the code used to send selected songs to media player and play one after the other. also need to be able to...

I'm using ms access 2013 i have a project where i need to create a touch screen jukebox. my problem is that i have a textbox and a list box. the list box has all my track and i'm filtering from the textbox. when i use my keyboard the filter works fine from the textbox. but when using the touch...

i have a form where i'm using a numeric keypad through touch screen. when pressing the onscreen buttons the numbers and letters should appear on a combo box and when enter the combo goes to the specific record. Now the preblem is that if i form the code "CH2525" the letters and numbers appear...

i'm using ms access 2003. i've got a form that i placed 7 different text messages inside which i already can hide. what i need to do is to unhide them but one every day. for example: "monday" text must appear only on monday "wednesday" text must appear only on wednesday .... and so on monday...

I want to create a button to tranfer dates to a combo box The date that i need to be tranfered is the first of the previews month, that is: if today is 02/02/2011, i need the tranfered date to be the 01/01/2011 how can i do that in vba code thanks

I CREATED NUMERIC BUTTONS TO NAVIGATE THROUGH RECORDS. ONCE I TYPE THE NUMBER I NEED TO CREATE THE ENTER KEY SO THAT I CAN GO TO THE SPECIFIG RECORD. I HAVE THE FOLLOWING CODE: Me.Combo117 = Me.Combo117 & "2" AND SO ON FOR ALL NUMBERS. FOR THE ENTER KEY I HAVE: Me.Combo117.SetFocus...

i have an excel file named form.xls i would like to create code by pressing a button to open that form.xls, print the active sheet (sheet2) and the close ms excel. can somebody help me? thanks