Search results

Hello, just to follow up on this, I went ahead and tried wildcards with other queries and there is no problem there- I get good data there. Also, I don't have any problems searching with an asterisk in a table. Re-creating the query from scratch in a new query window doesn't help- it gets stuck...

Hello, I am in Access 2003. I have a select query which started exhibiting strange behavior last night (worked without any problems for months up until this point). This is a query which selects payment data- how much someone got paid for a certain task. It has several parameters- four date...

Hmmm... I am trying to figure out why I'm getting the error. My InvoicetoSearch textbox is unbound and has a blank format- the same format as my InvoiceNum control. I am playing around with it to see where I'm going wrong. In the meantime, you mentioned that there was a way to get the form to...

Hi Sam, I made a textbox called InvoicetoSearch and a button. In the button's on click event I put: Private Sub FilterInvoicesButton_Click() Me.Filter = "InvoiceNum = " & Me.InvoicetoSearch Me.FilterOn = True End Sub I just tried to test it and I am getting a run-time error number 2448...

Ooh! This is fancy stuff!! It will take me some time to look through it and customized for my form (which is rather simple, really- nothing fancy in it- well, until I put your code in, that is!) I have started looking into the filter approach that Sam outlined for me. I will explore both ways...

Can I run this by you just so I know I am understanding correctly: -On the Invoices form, I need to create an unbound textbox where the user would enter the invoice number to search -create a button that the user clicks after typing in the invoice number to search. The on click even of this...

The locking for edits is one of the pieces that I need to have for the form, yes, but the other one that is a concern for my user is the ability to jump to a specific invoice by typing in the desired invoice number in the invoice field, without having to scroll through all the invoices...

Hi Sam, I just tried setting the allowedits property of the Invoices form to No and then unlocking the controls. This seems to have the same effect as having the controls locked- I am not able to type in the fields to jump to a specific record. Are there any workarounds to this? Thanks!

Hi Sam, sorry if this is a really basic question- where would I have to set that allowedits property? In the on load event of the child (invoices) form? Thank you!!

Hello, I have a nested set of invoice-per-vendor forms. Main form: vendors child: invoices grandchild: invoice details I am using this form for the user to ONLY review existing invoices- no data entry/editing should be happening here. I set the locked property to 'yes' for the textbox...

Hi John, Thanks so much for taking a look at this problem. I looked at the forms in the zipped sample, and that's pretty much the set up I have right now. I'm sorry if I'm being dense, but I don't undersatnd how a static invoice ID would help me update the related records in the child form. What...

Hello, I have to aapologize in adavance. If this is repeat topic- I am sorry- but I haven't been able to find the answer, most likely because I am using the wrong search terms. I am not very adept at creating forms and the form terminology is beyond me. Here is the problem that I need help...

I am blushing with embarassment! Thanks A MILLION, Brian!!!!!!!!!!

Hello, This is most likely going to be the silliest thread in this forum- but for the life of me, I cannot see what is causing a 'syntax error- missing operator' error in this query. All the table and field names are correct, as far as I can tell all the commas are in place and I just checked...

Hi Pat, The between clause is not the only thing I tried- I also tried 'where FTEmonthstart = [start date]' since that field only contains the frist dates of the month- setting is as equal should work. So even the between clause as I have it written should, theoretically work. I made a little...

Hehe- yes, I did check for my own stupidity (this time- it took a while to learn to do that). But no- missing data is not the issue here. There is most definitely data in all months between June 2011 and July 2012. I tried a few different date values the problem is the same for all of them. When...

Hi Bob, just tried it upon your suggestion. Unfortunately- didn't help- getting the same blank results screen. Thanks for giving this a shot!

Hello, I have a query that works just fine but when I put it a where condition, a blank results screen appears. I have tried putting in the condition in the subquery in the from clause and also in the main query, but nothing works. As soon as I take out the where condition, everything works, but...

Thank you! Works like a charm!!!

Hello, I have been playing with different version of the following line to convert the first character of a string to a superscript but nothing in working. The line, as is, converts the whole cell contents to superscript. Would anyone be able to point out where I am making a syntax mistake...