Search results

I have field with decimals and it's showing correctly but I want to custom format the field, add some text. My report format is ="~" & [Decimal] but I'll got 10 or 3 instead of 1,0 or 0,3. In a table is the field showing correctly. Should be easy, I'm sorry. Thanks.

How to change primary key in main table and in subtable at once?

I'm managing a font database and want some kind of report. The question is how to format records with fonts found in database? All the fonts are installed to system. Thanks.

Access help doesn't contain any encoding values. I use OutputTo and want the file appear in Baltic. Thanks.

In a report there is a text box which has the following source: ="Title: " & [field1] & " sometext " & [field2] General question is how to format those fields? Thanks.

How to generate a filename that uses date values? For example, date value is November 21, 1999 and filename should be 21-11-99. Problem was how to separate date parts. Thanks

How can I type minutes & seconds only into date/time field. Formatted as nn:ss and pattern as 0:00:00;*. AND here comes that annoying must-be-typed zero, I want to type mins and secs only. Thanks.

Oh god, since there are NO OTHER users logged on I can't understand where's the point. Is my database gone?

How can I set font size of a field based on a value of another field? Example, font size of field1 should be 126 points cause field2 value is 126. Thanks.

How to make the following accept numeric value? Private Sub Kood_BeforeUpdate(Cancel As Integer) If DCount("[Kood]", "asukohad", "[Kood]= '" & Me![Kood] & "'") = 1 Then MsgBox "Already here." Me.Undo Cancel = True End If End Sub

How to format data depending on value's lenght. Example, format a 8-characters value 12345678 to (123) 45 678.

How can I make Access XP show quotation? Example. Report output should be Title "title" and I used in control source ="title "" & [title] & """. Access, of course, is confused. There must be a way to present quotation.

How can I retrieve customized contents text output file when to click button? @ the moment I use DoCmd.OutputTo acOutputQuery, "myQuery", acFormatTXT, "96.txt", True

How to make Access XP understand minutes and seconds only? Like 110:06, not 1:50:06?

I can edit all data when I select or type a value from primary key combo box. But how can I edit primary key value itself so it will apply all related data? I have a form with a subform. I tried to duplicate a record but of course duplicate value errors appeared. I think an additional text field...

How can I edit existing data through a form? When I enter a value to Catalogue # field (this is primary key field) then all related data should be visible (it means something autofill stuff) and no '...would create duplicate values...' messages. Any code part or can be simplier? Thanks.

Access gives me a syntax error every time when a expression contains a comma. For example, using =Left([Country), 3) Access reports omitted an operator or an operand, invalid character or comma, or text without surrounding it in quotation marks. Where's the mistake, I exactly copied syntax from...