Search results

  1. C

    Query related to different buttons

    Thanks! I understand what you are saying and it has more logic. I will try this, and if I encounter some problem I will post it.
  2. C

    Query related to different buttons

    What do you mean to hard code the value for each button? How can I do this? I don't know what the tag property is...I will search about that.
  3. C

    Query related to different buttons

    I want to open a table, like the table that open when you run a query. Or it can open a report associated to that query result... The problem is the query to be related to "all the buttons" and to show different things when I click a different button.
  4. C

    Query related to different buttons

    I have a form that has like 20 buttons (each button is related to a bed), like a scheme of where are the beds in a inn. I want to know if it is possible when I click in button 1 to show me the results of the query. The query would be to show the time that the bed is occupied (so it will have...
  5. C

    Add multiple similar records with one button click

    That doesn't work very welll. I don't want always to create 20 records, the amount of records I want to create is equal to the value I put in the number of partners textbox. The stamp_id is the primary key of my table and an autonumber, so it can't be repeated. So the line vID = txtboxID + I...
  6. C

    Add multiple similar records with one button click

    Hello! I have a form to register some data from when a group "passes by" a inn to get a stamp when they are doing a peregrination. The data is date, route, path, start local, transport method and number of partners (basically how many people are in the group). I already have a save button that...
  7. C

    Button locked and Text Suggestion

    Thanks! It works pretty well!
  8. C

    Button locked and Text Suggestion

    I have another question. Is it possible to in the city table have a country associated to the city and then in the form, create a new combo box where I can choose the country and then in the other combo it would only appear the cities of that specific country. I know this is possible. The...
  9. C

    Button locked and Text Suggestion

    It works very well! I will try to talk to my teacher too see what he says about it! What did you think of my solution in the Edit part of my last post? Does it work or it would be problematic somehow? Thanks again! :)
  10. C

    Button locked and Text Suggestion

    Hello! This didn't work very well. The problem is: I have the table only for the cities (fields are city_id and city_name) that already have like 200 cities in there. My main table still doesn't have any data in there, because it is supposed to store data about the people that want to make a...
  11. C

    Button locked and Text Suggestion

    Hum...I don't think that my teacher would like that (the remove the city_id thing) but I can try to talk to him about that. In the meantime, is there another solution? If not, and you could tell me how to update the records, I already have like 200... Thanks!
  12. C

    Button locked and Text Suggestion

    I tried that and this error appeared: Microsoft Access can't set the LimitToList property to No right now. The first visible column, which is determined by the ColumnWidths property, isn't equal to the bound column. Adjust the ColumnWidths property first, and then set the LimitToList property...
  13. C

    Button locked and Text Suggestion

    Thank you again. I have put the code with the right names in the afterupdate of the cities combo but the problem persists. When I put some random name that is not in the cities table the error "the text you entered isn't an item in the list". I will send you the database if you want to take a...
  14. C

    Button locked and Text Suggestion

    Hello, thank you for the fast answers! I have some trouble understanding this answer. Should I do it with a query or something? Imagine I have a table with some cities, and then a Form from another table where I need to put a city where a person lives. This is what I have done: In this Form I...
  15. C

    Button locked and Text Suggestion

    Hello all! I did a basic search about this issue but I couldn't find anything related. So, is it possible to create a button that is locked until all the fields (text boxes for example) are filled, to make sure that all the fields are completed before "confirmation". Another question, is...
  16. C

    Hello from Portugal

    Hello, I am a student and I have to work with Microsoft Access to make a database for an inn. I have registered because I want to clarify some doubts that I have. All I have learned in classes is pretty basic stuff and I don't know a lot of code but I am a fast learner and most of the times I...
Top Bottom