Search results

Glad I could be of help

I'm questioning Shari'a. As anything is subject to interpretation, so is Shari'a. But if you were to follow closely its predicaments, living in a western world country would be impossible. I'm not talking about extremists, I'm saying it's an old, outdated and largely incompatible with...

Use a select query in your listbox to filter based on whatever record you're viewing. On the Load event of your form put something along the lines of: Dim mySQL as String mySQL = "SELECT callday, calltime, etc FROM tblCalls WHERE fkIDCustomer = " Me.yourlistboxname.rowsource = mySQL &...

Since you mentioned only one field is different, and that field is the card number, I take it you don't have a date field. You'd use an update query, but how do you discriminate between newer and older data? If you only ever add new data and there's no risk you import older tables for whatever...

Please refer to this article. Use the path string as GraphImage variable in the example provided. I haven't tested this so can't tell if it'll work - let us know!.

I'm not strongest in tables, but I sense a junction table could be useful, so you might want to move this thread to the proper section. In short it depends on whether Person A can be loaned more than one item at the same time. Anyhow, when tables are set-up properly, you expect a listbox or...

I'm assuming on your call history table you have a fk linked to customerID in your customers table (I shouldn't be assuming as it takes longer to identify the correct solution for you, and therefore wastes more of both your and my time - please read the guidelines). Under that assumption, what...

Aziz is allowed to live in the UK probably because he abides by its laws. Consider this, Aziz: you are allowed such freedom there, whereas in a country based on Shari'a anyone not following the leader's religion would be persuaded by means of violence, stoning or imprisonment. Also consider...

Glad you found a solution

are other file operations allowed? can you, say, copy and paste it elsewhere and open it from there?

No problem, glad you could solve it. As for the button on the form_load event you could use a DLookup or recordcount to act on the .visible property of your button. Private Sub Form_Load() If Nz(DLookup("mail", "t1"), 0) = 0 Then Me.cmdDelete.Visible = False Else Me.cmdDelete.Visible =...

I mean it looks to me like you've properly set up everything, you just need records in the table so that the main form can read an ID to link to the subforms.

It looks to me like everything is in order. The linked field is safety_category_class, so i created a record in tbl_safety_review_situation and everything went smooth, form, subform and nested subform.

Please provide an example of what is not working, why, and if you have taken any steps and which to try to address the problem. Also refer to the guidelines.

Best of luck to you!

I think I get it, althought I'm not too sure what you mean by passive or snapshot format. You would need to go into further detail and try to explain what is going wrong and where you're not succeeding, if you want me (or anyone else) to help.

Well yes, you could bypass it although I would look into the matter to fix your code so it's error free. Anyway, you'd use an error handler like this to bypass it: '....code On Error GoTo errHandler '...more code Exit Sub errHandler: if err.number = 7874 then resume next Else msgbox...

Please note that I don't care and don't want to argue about who's right or wrong. I'm just trying to help, and in programming precision is usually crucial to success. Please refer to my last post, and elaborate further if I haven't answered your question.

I must've misread your post. Should I assume the "selected fields in one table" you mention are in fact the rows of a datasheet form? If this is the case, a routine would go along the lines of: Private Sub UpdateTable_Click() dim strSQL as String strSQL = "INSERT INTO yourtable...

I eventually read the original post :D