Search results

My first build of the frmZahtev was just like that, tblZahtev as Data Source and 2 subforms (one for tblDete other for tblPorodica). That seemed to work, but because after putting the subforms the frmZahtev was to big (lot of scrolling), and I abandoned that idea (it wasn't estetic enough for my...

I'll elaborate each of my answer. My combobox is bound to the intPorodicaID field in tblZahtev (because that is the place where values from the combobox would be stored, and they are integers). The row source for the combobox is set to following query: SELECT tblPorodica.inrPorodicaID...

tblSkala is not joined to any table (you'll see if you look at the sql code). I gave You database relations on that picture, not the qry relations from the query builder. The tables that are joined int this query (qryZahtev) are tblZahtev, tblTipDokumentacije, tblPorodica, tblMesto, tblDete...

Could You please elaborate this? What do You mean by "expiry date is preset"? How it is preset? How do You code backdate? What is backdate, how does it work? If I create a property for the database, put the license key in it, and then make .accde database, can I later remove that license from...

Because this qry (and its code) doesn't perform as expected on the form I'm using it: SELECT tblZahtev.intZahtevID, tblZahtev.dteDatumZahteva, tblZahtev.txtBrUgovora, tblZahtev.bolDoc1, tblZahtev.bolDoc2, tblZahtev.bolDoc3, tblZahtev.bolDoc4, tblZahtev.intDocTipID...

Is there a way to structure this SQL statement without JOINS just using the WHERE clause? Thank You

Thank You for Your answers Wiklendt, my code works as is, I have no complaints. I have tried the On Current event but the same thing happens. Thea reason I asked this question is because during the development its common to switch between views, and because the code doesn't work in other view...

Thanks for answers Uncle Gizmo, I made this code works. The TempVars where not crucial for this code to work, more important for me here was how to capture the value of the PK field when I click on it in order to filter the opening form correctly. Thanks again

What would be the best way to make backup of data in .accde database? Can this be done properly without first splitting the database? I prefer not to complicate things because only one user at the time will work with the database. Can tables (with data) be exported from .accde database? Thank You.

Why is this so important? I mean, this happend to me twice with wo different codes, so I'm guessing I doesn't have to do anything with code itself but maybe with the event(s) that load the code (the report opens in Report view and then the On Load code triggers and fills the control but when I...

I've read a little about this, I thought why not try it, but now I have a question(s): 1. I've first created database (tables queries, forms), can I split it now? Will the VBA code work if I split the database now, or I should have first split it and then develop (queries, forms, etc.)? 2...

I have a report which is fueled by a query, but besides that has one unbound text field which is filled with data in the forms Load event. The report is build to open in acViewReport view but when I switch to Print Preview view the unbound textfield is empty. When i switch back to Report View...

I tried this code: Private Sub btnFormat_Click() Dim dteSistemskiDatum As Date Dim dteFormatiranDatum As Date dteSistemskiDatum = Date dteFormatiranDatum = Format(dteSistemskiDatum, "dd") MsgBox "Sistemski Datum = " & dteSistemskiDatum MsgBox "Formatiran datum " & dteFormatiranDatum...

I noticed that date imported to VBA depends on Standards and Format, in Control Panels, Regional and Language Options settings. For example in one regional settings the date is displayed in format 01. September. 2009 while in other regional settings the date is stored like September, 1st 2009...

Hey, thanks for the awesome site DCrake, cheers! :)

[SOLVED] Please explain this code I think I've solved the problem, everything works, for now :) Here's my code: Private Sub intZahtevID_Click() On Error GoTo Obrada_Greske Dim objekat As Object Set objekat = Screen.ActiveDatasheet.ActiveControl DoCmd.OpenForm "frmZahtev", acNormal, ""...

I have a form with a button that opens another form: The code for a button is: Private Sub btnSpisakDece_Click() On Error GoTo Obrada_Greske DoCmd.OpenForm "dtshtFrmDete", acFormDS, , , acFormReadOnly, acDialog Izadji_Ovde: Exit Sub Obrada_Greske: MsgBox Err.Number & " - " &...

Thank You for Your answers guys, I have a few questions. This code I've shown You is used to open the form when You click on hyperlink on this picture: Can this code be recoded without using the code context object (is there other way of capturing on which record I clicked in the datasheet...

This code is a converted macro which opens a form when You click on a hyperlik in datasheet table: Option Compare Database '------------------------------------------------------------ ' HyperlinkOpen ' '------------------------------------------------------------ Function HyperlinkOpen() On...

The "person" is none other than Microsoft Access 2007 Query Builder :) How would You write the same query, but better?