Search results

I can only say that study will help you on your way. A good way to start developing your db is to make a demo on paper, create tables and imagine how a user would like to use your application. You will make mistakes, things will not work and then you will know exactly what to ask :) . Good luck!

That is a lot to ask.

The only way to overcome your problem is move your db, do your thing an place it back... But I have to back Micron, in a situation you describe, a split must be made be & fe.

Just my penny.... Isn't it much easier to have all choices in a single (unbound)form? Like use a non-visible combo / listbox that becomes visible after the timecheck? I think this is a very complicated way to get a result.

OOPS, sorry, splinter in the eye!!! the message I got was : Your post in the thread Setfocus to newly added record in subform was moved to Setfocus to newly added record in subform. Reason: I moved your question to a new thread where it will get more attention. After that message...

My post was moved out of that thread by Cheekybudda.

Is the form in your subForm, Bound or Unbound? try: Me!subfrm.Form.RecordSource = sql Me!subfrm.Form.Requery In my apps i usually do something like this ("Uren_perWeek" is a bound Form) Sub kzeProjecten_AfterUpdate() Dim SQLweek As String Dim SQLstring As String SQLstring = "ProjectNr = '" &...

You are deleting records with a button on a subform? If that is the case you have to go back to the parent Form. (the one with the subforms) With Parent![SubForm-Name] .Form.Requery End With If it's something else we probably should see what you are working on.

You have to requery the form in the subform. With Me![SubForm-Name] .Form.Requery End With

No Micron, I was just showing the solution(in another post) I use to inserting a new record donkey proof. (in another post) In this application I struggled with the clients knowledge of IT. The choice of her client is via a combo, showing personal info. Sometimes she needs to add info to or...

I have the idea Saledo2000 is using the date to create a log. Date and ID should be written to a separate table. Correct me if I am wrong but he just needs an append-query with a selection of ID_Numbers and todays date.

Update Query?

Steve Bishop has a youtube channel protect your frontend I used his lessons.

yes, that will be the case. You will only see more from "B" when you have multiple records linked to a single record in table "A"

Sorry, reading your question again, I think we are on different tracks.... As I am trying your steps I can not think of a solution! As far as my knowledge feeds me it will only be possible if you create a new form with two subForms. First subForm shows table "A" as continuous form and the second...

You have a table "A", and create a query from it, which shows on a Form. In the subForm you link to table "B". After adding info to table "B" you want to open a new form which shows the combination of "A" & "B"..... I guess you should just create a new query with the linked records from "A" &...

a query is just a view of a table... try a new query and show that in the new continous form. (by the way, a hard question to read)

I am using a separate, unreferenced, form to input a new record to a client-table. This extra form has a check-sequence before it will add the new record. Maybe it is a bit more work but the user can't add an empty record to the database. Sorry for the dutch example in the attachment :-)

as promised, to solve my problem I created an new textbox on the form. This new field is called in the opening SQL statement (concate of Tag & Function). My search string is adressing this new field and the result is showing the right records. Thx all for the input, Rene

Dave, I was also thinking of the concatenate solution. I will get to work with that one first. The link from CJ_London also has some nice suggestions. Thanks all, I will carry on and, when I will not forget, post my solution when I reach one.