Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Panchovia
  • Content: Threads
  • Order by date
  1. Panchovia

    start another access dbatabase from an access database

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

    How do you add the values of a date ? dd , mm ,yyyy together

    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")
  3. Panchovia

    Like operator oops

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

    nested for statement in c# visual studio express doesn't work

    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++) ...
  5. Panchovia

    how do you solve error: missing function header (old-style formal list?)

    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; }
  6. Panchovia

    allegro lib doesn't run on windows 8 ms visual c++ 2010

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

    C++ pattern problem

    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++...
  8. Panchovia

    Counting how many times the right part of a four digit number appear in the database with a query

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

    How do you get the day name not the date value in ms access 2010

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

    Dtpicker code doesnot prefrom as it should

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

    is it possible to refer to the recordset option in a macro ms acc 2010

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

    Ms access 2010 full of code errors and bugs

    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()...
  13. Panchovia

    Code to control checkbox datepicker ms access 2010

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

    sum function in access 2010 query problem

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

    Compare data in the same database

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

    Year: Val(Right([Paidfor],4)) is this code correct

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

    formating a date field to month and year only ms access 2003

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

    Number field do alfa numeric update

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

    add date and time to the output to from access to excel

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

Part and Inventory Search

Back
Top