Search results

Hi everyone again, I have a date field in a query and I want to convert it to a datetime one. e.g I want 01/01/2017 to become 01/01/2017 00:00:00 but, result should also be a date field, not a string (as a Format function outcome) Any ideas?

Hi again, I hate asking questions every step of the way but I'm really stuck with this (again). I have a couple of forms open in dialog mode. Last one (the one in front), has a command button to open a report. Problem is : When I open the report in WindowNormal mode, it opens behind the forms...

Hi again. Here I am trying to work with a combobox in a form that picks percentage values from a table. Questions: What data type should the percentage field in that table have? How I could add new values to that field on the NotInIist event of the combo? (I know how to do it with everything...

Hi everyone, Here I am again with a really tough brain teaser. We have some events going on, in which Customers (tblCustomers), rent Seats (tblSeats) to attend the event, paying a daily Rate (tblRates) who’s Min and Max values are being predefined by the user, according to Seat Category...

Hi everyone again, Ok that’s a tough one. I’m building a soccer league database for my local league. There are tblTeams, tblPlayers, tblRoasters, tblPeriods, tblRounds, tblMatches, and tables tblHomeGoals, tblAwayGoals for keeping track of every match’s goal scorers. The way it is...

Hi everyone again, I have a table with some data, the kind showing in the following image: I want to query (or whatever else needed) this table and get the groups having same number of members the way shown below: Group D Group E 8 Group D Group F...

Hi everyone, Suppose, closing a form, I want to pass a value to a control in opening form's subform. This subform control doesn't exist on opening main form. Is it doable and how? Thanks

Hi everyone, I have two forms, FormA and FormB. On FormA I have two controls "SupplierID" and "CustomerID" that are comboboxes from which I select values respectively. On FormB there are the same two controls, only this time they are textboxes. With a command button on FormA I close FormA and...

Hi all, I have a combo in a form, where I enter values either by picking one from the list or writing a new one (on NotInList). Saved values may also change in the future. I want to trigger a procedure (besides saving the record) after saving a new value, or changing an existing one, without...

Hi everyone, I have an unbound MainForm, bearing two subforms (SubFrmA, SubFrmB). The two subforms are related, so when I pick a record from SubFrmA data in SubFrmB changes showing related records. SubFrmB contains thousands of records related to every single record in SubFrmA, that’s why...

Hi everyone, I’m designing a music collection database, where I input all my music by Artist, Recording (album etc.), Media (CD, LP, mp3 etc.). There are two significant tables in this database, tblArtists and tblRecordings. There is also a data entry form frmRecordings based on...

Hi there, Every time a new record of a bound form is saved, a small piece of code in the AfterUpdate event of the last control of the record, adds a new record to another table (that means apart from the new record on the table the form is bound). Where (in which event) do I put the code to...

Hi everybody, I use this line of code to insert records in a table CurrentDb.Execute "INSERT INTO tblTransactions ([Account1ID], [Account2ID], [TransactionDate], [TransactionType], [TransactionCategory], [Amount])" & _ " VALUES ( " & Me.[Account2ID] & " , " & Me.[Account1ID] & " , #" &...

Hi everyone, long time no see, trying to avoid bothering you all beautiful people with silly questions. Well, I got a tblTransactions, that holds records of everyday transactions on multiple accounts, and bears fields like TransactionID (PK), TransactionDate, AccountID, TransactionType...

I’m trying to design a database that will keep track of the value of products in stock, for several stores. So we have days with buys, days with sells, days with buys/sells, and days with nothing. 1st issue is that, for those fine days of no transaction, there will be no record, none, nowhere...

Hi everyone, I use the following code behind the BeforeUpdate event of a control, to validate input. Private Sub StockPrice_BeforeUpdate(Cancel As Integer) 'strings used for the MsgBox Dim strTitle As String Dim strMsg1 As String Dim strMsg2 As String Dim strMsg3 As String Dim strMsg4 As...

Hi everyone, I have a Main form (MainForm) with two subforms (SFormA, SFormB). These SForms are connected to the MainForm by a control (controlA) and connected to each other by a control (controlB) via an unbound control in the main form, in order to change data in SFormB according to selected...

I have a totals query that shows results in a chart. It takes a parameter to limit results, by a combobox in a form. Parameter in the query includes the OR “*” expression, in case someone wants to get the results unfiltered. The Combobox in the form, has an AfteUpdate event that opens the...

I have a table with a field TDate (dd/mm/yyyy format). A query with calculated fields is lying on this table. I want to put a date criteria in this query, by a combobox in an unbound form, where the date format has to be “mmmm/yyyy” and has to be updated as new TDates come in. Trying...

I have a table (tblSales) like the one shown. I want to group it by SalesDate, SalesPerson and Product, summarising the Amount, not necessarily using all criteria at the same time, but criteria given by a form (or 3) with a combobox. I want to be able to chart results in a report, and...