Search results

I have a query that keys off on a status field. I just use Nz(status) and filter out all other types but 'W'. This allows me to show any record for each ID with that status (there is only one or none per each ID) but it also shows the records of ID's that have no status (one record per each ID)...

Error I'm getting 'The expression you entered contains invalid syntax, or you need to enclose your text data in quotes. I can't figure out where it's wrong If Dcount(Nz([StatFlag]),[Books],[StatFlag]="W") >0 , ((Nz([StatFlag])) ="W" , (((Nz([StatFlag]))<>"R" And (Nz([StatFlag]))<>"M" And...

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 &...

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 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...

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...

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...

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...

I keep getting a Syntax error on this code and I have looked at it till my eyes wore out! Can anyone help?? Code: Private Sub Transfer_WN_Books_Click() Dim strSQL As String strSQL = "" strSQL = strSQL & " INSERT INTO Books" strSQL = strSQL & " ( Title, Author, field222, field2, Notes, Amazon...

Hi, Hope someone can help me. I am trying to update a 2nd table 'WhatsNext" after entering a date in a field "ReadDate" (mmm-yy format), in table "Books". There is a slight variation as I must reformat the date for another filed on the form "MyDate". I can see the date go into in "MyDate" upon...

Hi, I'm a disabled old fart who just upgraded to access 2010 from 2000. I am self taught (what little I know!) I am looking forward to getting involved in this forum and I am sure i will need many answers. Thanks in advance!