Search results

Hi, Im trying to edit database records via my website. I have the code done except that one line keeps bringing up errors. The MYSQL statement has incorrect syntax and I cant get it right. Id really appreciate help!! Many thanks inn advance: <% Dim DataConn Dim CmdUpdateRecord Dim MYSQL Set...

Hi, can anyone tell me if its possible to specify the font on the 'Browse' button of an 'INPUT TYPE=FILE' field? I know you can change the font in the text box, but I can't change the button font. many thanks

Hi there, on a website Im designing, i have a searchable shop which is populated from an access db. You click on a thumbnail image in the shop and it gives you more details about the item on another page; this is done using the form method post action, and the extra details are stored in a...

I have an image in a report which is there on screen but doesnt print on my inkjet. Have tried bmp, jpg, linked and embedded, nothing works. It prints on my laserjet, however. Even so, Im sure it's not the printer settings as I print images all the time. any ideas gratefully received!

Hi , does anyone know how to put label vertical text the opposite way round from the default 'Vertical yes/no' property setting (access 2003)? (Ie: it rotates the text 90 degrees, I would like 270 degrees) thanks in advance!

Hi, Is it possible to filter out entries beginning with a capital letter with a query? Ive tried Like UCase, but that doesn't work, and there is no upper case wild card. (I am creating a book index and want to have a look only at the entries that are people's names) many thanks

Ive added my own navigation buttons as I needed to add some code to them, but when a user gets to the first / last records & presses previous / next record, they get an error message 'cannot go to the specified record' and have to close & reopen the form. It's prob. quite simple, but how do I...

Hi, I am having a problem with a form in that I can no longer add new records to it! The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message...

Hi, I am having a problem with a form in that I can no longer add new records to it! The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message...

in a query I am calculating DateDiff. I have an expression which puts a price into a column if datediff < 30. When I try to total that price in a report (in the groupby footer), with the expression =sum([thenameofthatpricecolumn]) I get a 'data type mismatch in criteria expression' error. I have...

Hi, I have a query which calculates the date difference between Invoice Due Date and Today, so that I can generate a statement which totals payments 30, 60 and 60+ days late. The query expression is: Current: IIf([DateDiff]<=30,FormatCurrency([Total]),""). However, when I try to...

Hi, hope you can help!?! I have an update query which on a certain date needs to reset order numbers in sequential order. As some clients don't order in each period, I have set 1 update query to set the OrderRef to 1, and want to create another update query which changes the OrderRef to...

Hi, help much appreciated in advance! I have an Invoice report set up running from a query (criteria set to 'is not paid'), but I can't work out how to get it to group outstanding payments from one customer onto the same page instead of giving each individual invoice its own page. Many thanks

Trying (as previous thread) to get a combo box to appear when running a query, instead of a message box, to display returned data 'Like' data held in a table. I did as Maxmangion suggested: [Forms]![c_RenewalDate]![RenewalEdition] is in my criteria row, referencing an unbound combo box in...

Like criteria and combo box When you put Like [Enter Criteria] into a query criteria row you get a message box which call up data from a certain table column. How can I get that message box to become a combo or list box displaying a list of all the data available in the column, rather than the...

I'd appreciate it if anyone could tell me how to edit the control tip delay in form design: ie: so as the controltip comes up much sooner than the default set by access? many thanks