Search results

Hi I am looking for a piece of code (either in access or excel) which will return all combinations of records in a particular field (or column of cells) which will sum up to a given value (or a close approximation thereof - ie a margin of error of, say, 2). In other words, imagine you have a...

Hi I am really stuck on how to do this. I am no vba expert but I took this project on thinking how hard can it be. Unfortunately it has totally flummoxed me :(. Essentially I have a table of historical interest rates (fields are : Interest_Rate, Rate_Start_Date and Rate_End_Date). Then I...

Hi I have a form which allows team leaders to verify information that their team members have captured. It all works fine while they are verifying records and moving onto the next record, but when it gets to the last record it obvioulsy cant go on to the next record and the verifier gets...

Hi Here is my problem: I have written a query which brackets turnaround times. The brackets in days are : 0-1, 1-3, 3-5 and so on. This is done in a select query where a calculated field contains the brackets as above. I then run a crosstab query on this query making the brackets field the...

Hello again gurus, In a login form I am trying to do a lookup on the user table and direct users to a specific form depending on their GroupID (User Group) in tblUser when they log in. The user ID is a TempVar that is added when a user logs in. Then I am trying to perform a dlookup for Group...

Hi gurus I have a form in which I have two combo boxes. The first selects tax type and the second selects query type. Different tax types have their own unique list of query types as per the Tbl_Query_Types. I want the 2nd combo box to only show selections available relating to the tax type...

Hi I have a database which contains a Public Function forecasting dates based on working days, ie excluding weekends and Public Holidays. I wish to update fields based on this formula, but I want the controls to default to this calculation so that the record source can be updated. If I...

Hi gurus I have a data entry form which has certain fields for which I require the information. I have set Validation Rules and Messages up for those fields in the underlying tables but not set them to required. These work as I tab through the form. However when I create a button on the form...

Hi I have included some conditional formatting on a report of mine. The only time this formatting appears is if I hover my mouse over the formatetd field. It does not appear when simply viewing the report or especially if I print the report. Does anybody know how to have this formatting...

Hi gurus, I am trying to figure out how to make a text box value required only if another text is completed. Lets call them [txt1] and [txt2]. So if [txt1] is filled in then [txt2] becomes necessary for the user of the form to fill in too. I am sure this must be easy enough but my limited...

Hi gurus I have built an access database, split it putting the back end on our work server, and distributing front end versions of the database to my colleagues. During current testing the performance of this database is reduced significantly as soon as more than one user logs in. Does...

Hi gurus, I sourced a great access db which filters data based on a companies name or tax reference number being LIKE user entered data in two text boxes. The results are displayed in datasheet format in a subform. I would like to be able to write this data to a table. ie trigger a make table...

Hi I am having a little trouble with my code here. I have a button on a form which opens reports on a particular Case ID. the button pulls up an input box asking the user to specify the Case ID to open the reports for. After that It should always print "Rpt_Profiling_Cases", then it should...

Hi I am having a little trouble with my code here. I have a button on a form which opens reports on a particular Case ID. the button pulls up an input box asking the user to specify the Case ID to open the reports for. After that It should always print "Rpt_Profiling_Cases", then it should...

Hi I am having a little trouble with my code here. I have a button on a form which opens reports on a particular Case ID. the button pulls up an input box asking the user to specify the Case ID to open the reports for. After that It should always print "Rpt_Profiling_Cases", then it should...

Hi gurus Backgroud: I have built a very simple database which essentially has a form with buttons which shows the results of various queries based on a criteria entered in a text box at the top of the form on separate individual forms . I was having some issues in that some of the forms were...

Hi I have a form which users complete to profile clients. I have set up a few queries which are run from clicking on the lables of the fields they complete to show various data to help them capture that information. The form is a pop up form so that when the queries run they sit behind the...

Hello learned ones, I have a form which staff will use to complete their client profiles. To assist them in this endeavour I want them to be able to pull up queries which I have built into the database and whose criteria would be the Client_ID on the form they are currently viewing/editing. (I...

Hi I have written a database which creates TempVars for users when they login based on tblUsers. I now want to be able to call on this tempvar when, for example, a user completes a case or enters a comment on a particular case. The code used in the login form is as follows: Private Sub...

Hi I have been playing around with dlookups over the weekend, but I am unable to figure this out. I have a form for entering new cases into my database (call it "Frm_New_Cases") whose control source is Tbl_Cases. One of the fields in this table is "Reference". Now when I fill in the Reference...