Search results for query: *

Hi I am trying to run an access database from another access database with the following code in ms access 2010 Private Sub Command21_Click() Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"" "" C:\Users\Rudolf\Desktop\Signinfo playitmovie,1") End Sub

Hi I am trying to get a number from a date with the following code with out any succes Alias_Date number: Val([Alias_date],"dd")+Val([Alias_date],"MM")+Val(Alias_date],"yyyy")

Hi with the following code you get the last number search Like ("*" & [Search_which_Number ?]) Now if you swipe Like ( & [Search_which_Number ?] "*") you should get the first numbers this code doesn't work What is the correct code.

using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Pattern_1 { class Program { static void Main(string[] args) { for ( int i = 1; i <= 10; i++) ...

When I run this code above error appears how do you solve this error #include "stdafx.h" #include <allegro5\allegro.h> #include <allegro5\allegro_native_dialog.h> int main(int argc, char* argv[]); {allegro_init(); allegro_message("Hello World"); return 0; }

I have tried to run the allegro lib in microsoft visual c++ 2010 but I think it does not run because the allegro.h file is a dos file for windows to read it you need the dosbox , any one knows how to make this file run in ms visual c+=2010 64 bit. Pachovia

The following code should produce the following pattern it doesn't. XXXXX XXXXX XXXXX XXXXX what code must be added to get the correct result? #include <iostream> #include <conio.h> #include <process.h> #include <string.h> using namespace std; int main() { int i,j; for( i=1 ; i <=5 ;i++...

I have the following query ms access 2010: field drawnumber should bring up the right part of the numbers 00 to 99 from the 4 digits number in the database the second field should count how many (records) with the right part of these numbers appears in the database I used the following code...

Day: Day(Format([drawdate],"dd/mm/yyyy")) This code should give you the drawdate name instead of the value or not if not how do you get the day name I've tried various options in ms 2010 none gives you the name of the day.

Private Sub Command86_Click() If Me.NewRecord Then If Nz(Me.Aliasdate) > 0 And Me.aliasamount = Null Or Me.aliasamount = 0 Or Me.Aliasdate = Null Or Mycheckbox = False And DTPicker6.Value = Date Then MsgBox ("No record will be added"), vbOKCancel Beep End If Else...

Code if me.recordset.recordcount = 0 then cancelevent else if me.recordset.recordcount = 1 and me.Amount = 0 then Docmd.rumcommand accmdundo Endif Microsoft recommends you use macros instead of code how do you transform this code in macro Your help will be highly apprecciated Pancho

I have converted my database to ms access 2010. The following code worked ok sunddenly I get an error 2467.(one of the many) Private Sub form_beforeUpdate(cancel An Integer) If me.Quantity = 0 then Docmd.unCommand AcCmdUndo Else Datemodified = Date Timemodified = Time() Users = Fosusername()...

the following code will change the date in the date field to the current date the check box will checked on current event If Me.Newrecord then Me.Dtpicker6.value= date End if what code do you have to use to control the checkbox aside of the date so it comes without the check mark to force the...

I've tried to get a sum in access 2010 of my transaction table joined on my client table properties unique records Payments:sum((([quantity*Price))) The query result gave me 3 totals, for the three years of transactions in the transaction file. Is it possible to get one sum of all the years in...

How do you find the last record in a transaction table with acc of years of data of the year 2010 and the first record (or any other record) of the year 2011 in the same database to compare data. structure transaction table query clientno date amount reference

This code should give you the right 4 digits of the string (Paidfor) (example: may 2004)but I get a data mismatch error in access 2003, does the function val right exist in access 2003. if so what might cause this error. Pancho

I have a member database each member pays a monthly fee How do you correctly format the date field for month and year only in ms access 2003, do you make to fields for a range if a member pay let say 6 months in advance or can you do it in one field also. And how do you search after you make...

I have a old table with numeric field now I create a new table it must be changed to alfa numeric, format ---[99999] I created a update query to update the numeric field to the new table with the info of the old table without any success. Any suggestions.

This is the code I use to sent a report to excel, and I want to add date and time to the sheet . DoCmd.OutputTo acReport, "standnew", "MicrosoftExcelBiff8(*.xls)", "C:\documents and settings\Acessdata\My documents\standnew", False, "", 0 I have also tried some other code in access 2003 none...