Search results

  1. S

    Minimize

    Is there some way to minimize access main window when i pres minimize button on my form? I want to hide access window from end users.
  2. S

    Query with Replication ID

    Anyone has an idea?
  3. S

    Query with Replication ID

    I did that.. It seems that query does not recognize replicaton id for some reason..
  4. S

    Query with Replication ID

    Hi guys! I have a table Customers with replication ID field (CustomerID). I created a form for entering new records. When i try to run query based on tbl customers with crieria for CustomerID set to Forms!form!CustomerID there is null records in results. What should I do?
  5. S

    Sync tables

    Thanks for your effort! I really appreciate it! I tried something similar, but i need unique Customer ID in the Office Customer tbl. There are 5 laptops in the field.. and i dont have an idea how to make it work.. Data must be copied from laptop, added to office customer tbl and then...
  6. S

    Sync tables

    Tried to create append query. But there is a problem: Tables Customers and Visit are in relationship. Tbl Visit has Customer ID field. Append query copies data but Customer ID key is changed.. When the data is copied Customer ID is not 1005 for example, but 23(next available ID in the server...
  7. S

    Sync tables

    I created front end database on laptop. It does not have tables on it. It only has links to the server tables. When the laptop isnt conected to the server i cant use the tables. (There are small arows next to the table names in the navigation pane).
  8. S

    Sync tables

    Ok. I made a copy of datebase on one of the laptops and separated tables from forms and queries. Now I have linked tables on server. But, i need same tables on the laptop because men on the field wil not have connection with the server and they will enter some new data in the tables...
  9. S

    Sync tables

    Hi guys! I want to make a database on my company server. There wilii be two tables. "Customers", and "Visit to customers". There are 5 sales menagers in my company and i want them to colect information about customers on the field. My question is: How to sync Customers and Visit tables from...
  10. S

    Text to date

    It makes perfect sense! You re the man!!! :) Thanx again!!!!!
  11. S

    Text to date

    That was fast!!! :) Thanx a lot!!! Job done! Can you explain what are those numbers? (What is 7,2 and 4,2 etc)
  12. S

    Text to date

    Hi guys!! I have a large table that i imported from excell and there is a date field in dd.mm.yy. format (12.06.11. for june 6th 2011) I need a query that will convert that text field called "date" to date field. At first i wanted to enter date manualy, but there is more than 6000 dates...
  13. S

    Googlemaps form

    Problem Solved!!! Thank you a lot!!! :)
  14. S

    Googlemaps form

    Hi Guys! I created a form based on query that shows customer information. Now, i want to create embeded googlemaps object which will show directions from place A to place B where place A is place of my company and place B is City text box from my form. Basically, i want form to show me a...
  15. S

    Moving attachment field to another table

    Is there a way to move multivalued field (attached photos) to another table? I tried to use append query.. not worked for me..
  16. S

    Deleting specific record

    Solved with Delete query :) Thank you anyway
  17. S

    Deleting specific record

    I would use a primary key field. Machine ID for example.
  18. S

    Deleting specific record

    Hi guys! I have a table that contains, for example, 3 rows and 3 columns.. i need a code that will delete second row.. Any ideas? Thanx!
  19. S

    Copy Rows to excel

    Thank you guys!!! :) All done!
  20. S

    Filling a table from combobox

    Solved! SetValue... Thanks anyway!
Back
Top Bottom