Search results

  1. A

    Access 2000 linked tables via internet

    I have an access 2000 database in two pieces via local network One with tables and one with linked table, forms and reports Is it possible to make it via internet ?
  2. A

    Access form to web

    I have an simple Access db with 5 tables a form where the user must complete to run a querry to see the results I m looking for the easiest way to publish this form to website
  3. A

    Access from web (tablet mobile)

    I have a small db and i want to run one form with 2 querries It is possible to make it by creating some html pages and access it from mobile phone or android tablet? I have no idea how
  4. A

    Favorites in MDE ?

    How can have access to Favorites menu that i had in mdb ?
  5. A

    Question MDE has no toolbars?

    I have created a mde from access 2000 mdb I open it in a pc with Access2003 runtime but it has no toolbars Its ok like that?
  6. A

    Take second word

    I have a table with Surname-Names in one field Is it possible to have only the name as result ?? i want to sort the persons by their names (the second word)
  7. A

    query with calculation

    I have a query with these fields Field 1 Amount Field 2 Type (1 2 3 4 5 6) Field 3 Size (1 2) I want to calculate the amount in a new field like this If type =1 and Size =1 then amount=amount*10 If type =2 and Size =1 then amount=amount*8 If type =3 and Size =1...
  8. A

    how to display %

    i have a report like this car quantity value ford 5 1000 fiat 15 4000 opel 6 7000 total 26 12000 and i want to add the percent like this car quantity % value ford 5 19.2% 1000...
  9. A

    auto insert the name of pc in form

    i have a form and i want to auto insert the name of the pc in a field if the user fills another field
  10. A

    insert image path

    i have database with products and i want to add a picture for each one In the table of products i have a field "Image path" D:\dun.jpeg how can i insert this text-path from the form and not manually from table? for example :with a button ADD IMAGE from the form and browse file.......
  11. A

    Cross tab query with 2 column headers

    I have an access 2000 database and i want to make a cross tab query with 2 column headers but access doesnt allow that I decide to make the inverted cross tab query and its ok but now i want to use this in a report but inverted ex product type client1 client2 client3 a...
  12. A

    Can't save table changes

    i have a table with a date field with default value for new records date() when i change an other field and im going to save the changes access says that canntot save the changes because of unknown type date()....
  13. A

    Access upgrade

    I have an access db in a small lan (12 clients) I want to make an upgrade and to go to an more powerfull tool than access It is possible to do that easy with mysql sql server ........... or something else ? Thank you
  14. A

    Link to a web image

    i have a cars database because it is difficult to add 4000 pictures i want to know if is it possible to add a field that opens an ie page in google images to show results of images for that car? ex : model : Ferrari foto link...
  15. A

    Locked form

    i have an access database in lan and when 2 users are working in the same form and in different record the record will be locked ex if the first user is changing the date in the fist record the second user cant change another record...
  16. A

    Text Box with custom size

    i have a field like this W12,5 D100 W2,5 D100 i want to be visible the left size before the D100 ex W12,5 W2,5 how can i do that ?
  17. A

    next dates in report

    I have a report with a query and I want to give a date and in the report I want to have fields like headings with the next 10 days Ex I give 1/1/04 And in the report I want to have 1/1/04 2/1/04………….10/1/04 I tried to add fields like [date]+1 [date]+2……. But it doesn’t work
  18. A

    find characters

    i have a text field with "W XX" inside (XX=number) ex "W 32 sbiuisd" "W 25 isjoisjos" "hihiqhw W 31 sbiqweuisd" i want to have a querry that returns only the "W XX"
  19. A

    Sort by sum

    I have a report with products like this sum of product1 100kgr sum of product2 200kgr sum of product3 10kgr sum of product4 50kgr And i want to sort them by sum like this sum of product2 200kgr sum of product1 100kgr sum of product4 50kgr sum of product3 10kgr how can i do that...
  20. A

    email from form

    I have a form with email addresses and the code Private Sub Contact_DblClick(Cancel As Integer) DoCmd.SendObject , "", "", Me.Contact, "", "" End Sub When I double click a new email opens in outlook express and the email address is filled correctly in To: When I have default email client the...
Top Bottom