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!

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

Recent content by snuffi01

  1. snuffi01

    Copy an post from one access database to another database

    Is there a way to via an button copy an post from an table of an access database to another database?
  2. snuffi01

    Linux on Ipaq 5450

    Now i got Cygwin installed but not zsh. I cant understand how to install it.
  3. snuffi01

    Linux on Ipaq 5450

    I run it from a folder where i also have the file wich i try to change. My PC runs on Windows xp
  4. snuffi01

    Linux on Ipaq 5450

    I have a nice problem! I have an Ipaq 5450 Pocket pc, on this ipaq i have installed linux in an handheld version. Very nice with Linux in your pocket... My problem is that i now want to get back to Pocket pc as an operating system on my Ipaq. I have realised that this isnt so easy. I have...
  5. snuffi01

    Timeformat linked tables from Mysql

    The tables in Mysql database is in the TIME data type. When i look at the posts in the Mysql database it looks fine all fileds with time data type. But not in Access
  6. snuffi01

    Timeformat linked tables from Mysql

    I have an Mysql database and have linked some tables via odbc to an access database (access as an front end). When i open the tables in access i have some fields that should have a time format, like a phonecalls conect time. But the strange (for me) is the format of the time in my access table...
  7. snuffi01

    Strange time format on linked table

    I have an Mysql database and have linked some tables via odbc to an access database. When i open the tables in access i have some fields that should have a time format, like a phonecalls conect time. But the strange (for me) is the format of the time in my access table, the format is like this...
  8. snuffi01

    Unique number as text

    My ame is to have the access database to develop an text (user,date,time) witch is unique every time i make an new entry (press new). In my pocket pc i have the databaseprogram to in the text filed develop an GUID (witch this program only can do in an text field) this GUID shold not be...
  9. snuffi01

    Unique number as text

    Since Pocket pc manage to sync an access database (compare database on the pocket pc with the one on the pc and add any new entries that is missing and change any entry thats have been changed), I think that it will work only if iget my Access database to have its primary key field as an text...
  10. snuffi01

    Unique number as text

    The reasen that i want an text field as my unique filed is that my application in my pocket pc cant create an unique id as an number field but only as an text field. So i have to have the field as an normal text (and as primary key)field in access and process the "unique id" by code when a make...
  11. snuffi01

    Unique number as text

    My problem is that i must have the "Autofield" as an textfield. Would be nice i anyone had an example of code to make this possible, for example in my forms put some code "on new
  12. snuffi01

    Unique number as text

    I have an access database wich i sync over to pocket pc . My problem is the common unique number problem since when a make an new entry in the pocket pc i get the same number as in the access database on the pc. To overcome this problem i must have my autonumber field as an text field and the in...
  13. snuffi01

    Open record in a form depending on user?

    Is it possible to have some code on a form (on open) wich opens a specific record depending on wich user (using access security) is logged in? Example: the user Peter is logged in and he opens the user form (a form in wich he can change parameters of him selfe) the form opens the record wich has...
  14. snuffi01

    Calculate sum from subform

    I have an form with an subform with data in it. I would like to have an field in my main form witch calculates the summary from an field in the subform. I have tried this: =nz([KundkontaktTabellUnderformular].[Formulär]![Summa]). But i just get the data from the first entry i the subform, and i...
  15. snuffi01

    Hide subform if no data in subform

    I have an form with an subform called "Forstasidanaktuellt underformulär". I want that subform to hide if i dont got anything to show. (if no data in subform then you cant see the subform). I have tried this from an thread in this sitebut it doesnt work (Select one field in each of the...

Part and Inventory Search

Back
Top