Search results

It work for me but I also have set field format in table to 000000. Open table in design mode and set this field format property to 000000 and see if it works. Well, don't. You don't want default value to be 0, do you?

Set ProjectId field and textbox on form format property to 000000.

Yes, it's VBA code and I don't understand how can you not be allowed to use it, especially if you can use macro? I don't use macros so not sure if I can help you more. Quick googling shows that your macro should have two lines: 1) open form 2) GoToRecord (Record: New)

In "On Load" event of the form put this code: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub

What's Google? :rolleyes:

Or, if you insist on deleting: Private Sub btnTotalDestruction_Click() Dim db As DAO.Database Dim tdf As DAO.TableDef Set db = CurrentDb For Each tdf In db.TableDefs ' === don't touch system and temporary tables!!! === If Not (tdf.Name Like "MSys*" Or tdf.Name Like...

Format control on report like +0.0;–0.0;0.0

PasswordField=DLookUp("[RandomWord]", "TBL_PsWrd", chr(39) & "[RndWrdID]=" & Int ((253 - 1 + 1) * Rnd + 1) & chr(39)) This Int ((253 - 1 + 1) * Rnd + 1) will produce "random" number between 1 and 253 (ID of your random word)

Are you sure? I can see it in every DB I opened.

I don't know why would it matter if it's multi- or single-user while we're talking about FE only? Compacting Front End won't touch linked tables from BE, will it? Unless I'm missing something I think it's fairly safe operation. Anyway, that's up to you of course, I just think that simple...

Can't see why not. Just run it before application.quit code. And you'll probably need compacting your DB on close as well. Edit: And maybe check first if there are any img records in that table. It could something completely different in your case that causes bloating.

Right click on Navigation panel header -> Navigation Options... and then in Display Options check Show System Objects. And I just run simple delete query before exiting application: DELETE FROM MSysResources WHERE MSysResources.Type="img";

I had similar problem with my DB, usually around 3-4MB then suddenly bloated to 170MB. Took me some time and research but I found the culprit. My DB links pictures and stores paths only in tables but Access likes from time to time to cache some of them for no reason and without any rule (known...

It will, yes. But you didn't say in your first post what exactly would you like to achieve :) Does your code (on wrong password entered) close the form but still opens database? Or does it open form that shouldn't be open ("formname")? So what exactly should happen when someone enters wrong...

SomeLabel.Caption = DMax("DatePaid", "Dues")

Use Application.Quit instead DoCmd.Close (which closes form only)

Ok, think - how do you update rest of fields of the form? You need to do exactly the same with the field that contains path to the selected photo. Path is returned by variable strPath. So basically you need to set field (let's say its name is Pic1) value to strPath. myForm.Pic1=strPath Then...

I tried to achieve this look: while using subreport borders but then I realised it wouldn't work anyway as border is drawn around whole subreport. There's also no way to put a label on main report on top of subreport (afaik) so I had to get rid of subreport border and draw lines around...

If fDialog.Show = True Then 'Loop through each file selected and add it to our list box. strPath = Trim(fDialog.SelectedItems(1) Pic1.Picture = strPath 'and now you need to update Photo field in your table with strPath Else...

So... I took a bite yesterday and you were absolutely right, subreports were the way to go and it's piece of cake using them. Thanks a lot Gina! One more question though - do you know if it's possible to have a control (label for example) shared between detail and header on report? Like top...