Search results

My DCount statement is not finding a record that I know is there. I've spent hours trying different things but. . . Can someone please help me. Private Sub Transfer_WN_Books_Click() Dim ST As String ST = "H" If DCount("*", "Books", Author = " & Me!AuthorID & " And StatFlag = " & ST &...

Thanks for your help. My final solution is to do it all on the first form. You gave me the idea and this way seems to work. DoCmd.OpenForm "Books Detail", acNormal, , , acFormAdd, , "W"

I have a database of books. I have a combobox listing 3 different status W M R. W is for Whats next to read, M is for more books too read and R for books read or reading now. I can enter a new book by calling up the add a book form from any of those 3 forms. If I forget to enter a letter in the...

I would do that except for two things. 1. I already have all forms etc and info done. 2. I want to show all authors (even the ones without a whats next flag. To me this seems much harder to do. I would really like to keep it as is but with my original request of help.

I have a database that lists all the books I have read. The Table "Books" holds "AuthorId' "Title" etc. I have another table that is called "Whats Next To Read" which I store the next book that I will read from that author. It also uses "AuthorId" and "Title" etc. In the form, how can I look...

Thank You Nigel. You are exactly right!!! Whew!

PLEASE - I need another pair of eyes and a new brain to look at this code and tell me why I am getting a "Syntax error in INSERT INTO statement' Here is the code: Dim strSQL As String If (Nz(Me.Cover, 0) = 0 Or Nz(Me.Rating, 0) = 0) Then ' If the cover or rating are blank then don't put them...

No. There is no timer. I think it's just what Access does. It requeries about every 5 seconds.

I have a form/form and subform Datasheet but the main data entry is done on the subform datasheet. The problem is that it keeps re-querying or refreshing in the middle of an entry which is not good because it comes back in a different line. Is there a way to stop or delay the subform requery...

Here is the code: Option Compare Database Option Explicit Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _ "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long Private Type OPENFILENAME lStructSize As Long hwndOwner As Long hInstance As Long lpstrFilter As String...

I was wrong and right. Changing to editable (really Data Entry = Yes because it was always editable) didn't change anything except not showing any data(??), BUT when I SetFocus to another control it worked!! It's either something with the search (although I am able to set focus to it when form...

Well thanks for that. Now I'm only crazy - not dumb. Maybe it has something to do with the search routine or maybe because the datasheet is not editable?? I will check it out & let you know. Thanks for all the time you have spent.

There are only two forms 'A' is the datasheet and 'B' opens when I click the ID field of 'A'. I am clicking a close button on 'B' and want the focus set to the search box on the datasheet 'A'. It seems so simple yet ???

To mdlueck. I did as you said and each step is hit but still not working?? To boblarson. I changed it back as you said but still not working.

Ok I moved the close to after the other statements but still not working. I'm sorry that this seems like a simple problem that I should be able to fix but as you probably can tell, I'm not very good at this.

Here is the code I put on the close button on form 'B'. Private Sub Close_Form_Btn_Click() DoCmd.close Dim StrDocName As String StrDocName = "Books By Title" Call Forms(StrDocName).txtFindAsUTypeValue.SetFocus End Sub It does not set the focus to the search box. it stays on the field it was on...

Thanks for your quick response but I don't understand. The first form doesn't close when the other opens. Also I have tried to SetFocus on the control on the first form from the other form but not successful. Using Access 2010.

I have a datasheet form 'A' that I put Allen Browne's search box routine on. There is an ID field that gets clicked on 'A' to open a detail form 'B'. When I open form 'A' I set the 'OnActivate' event toSetFocus on the searchbox which works well. The problem I have is after I open form 'B' - do...

My program opens a dialog box showing file folders. When I click on a folder to open it, I get it in 'file view mode'. I change it to 'thumbs mode' to see pics and its works ok. The next time i click on a file folder it opens again in file view and does not retain the thumbs view. I converted...

Duh! Thanks, I guess I need a rest.