Search results

Hi IMHO You are not entirely clear what you want to achieve here. For instance a null new batch number before 194389. A null is not a value to BEFORE in what terms - date? Also, if the forms are linked you would not need to link them using VBA. Sorry but if i could help I would need a better...

Hi the question i have to ask (being asked for function like this all the time) is why does the information have to be exported? The users should have access to the database!! If I have this correct - the drop down choices need to be editable - create a form to add these

Hi Aron I am not sure if you can do this with continuous forms as the individual control is visible on all the forms - so if you change a property of one - they all change. I may be wrong though!! T

Hi Gary, Very good :) I will save a link to this for later! T

Hi all What about... Before the record is saved check if the field has been entered, if not put up dialog to ask if the value needs to be entered. therefore the user entering the form is asked directly the question. It does not rely on a report for someone to chase. On the report - if null put "...

I have developed a method to do this based on a search of 'Kick em out'. I have attached a sample. Basically each user have a copy of the front end. (If they try to use the original, i lock them out as I don't want the original corrupting. Which happened from time to time) When I want to shut...

Hi Gary My initial thoughts :) If you cut and paste to a table: Do you know what limits each field do you know when a new record is needed? Do the fields in the destination table need checking for type? You could use VBA to parse the string based on predefined limiters I think it could be done...

Hi All I think the key to this is the SboxSelectionForm method. Either scrap this and open the new form using code directly - using the openargs method to pass a reference to the form opening the new form. I think searching - cascading forms may find this :confused: Alternately modify the...

I think yes has to be the answer. Search MS Access Alarm Clocks on google... Quickly.... form with timer event comparing current time to set time etc. HTH T :)

I got this a whilst ago thanks to Allen Browne Function SQLDate(varDate As Variant) As String 'Purpose: Return a delimited string in the date format used natively by JET SQL. 'Argument: A date/time value. 'Note: Returns just the date format if the argument has no time...

Hi What do you need the 'N/A' for? Is leaving the field blank an option? What about using the NZ function in the report/form etc =Nz([FlashPoint],"N/A") I hope that has given you some ideas T

Hi Darth I think you need to look at your query. if you remove the parameters there are no results. Therefore, if I were you, I would rewrite the query without the parameters to show all possible results and then add the parameters later. I hope this helps :)

Hi All I wonder if anyone can shed light on my problem. I am generating an Excel file from VBA on my database. One of the requirements is to see the table results in a pivot table format. OK I thought - just use the pivot table automatically generated using VBA. My problem is this code works the...

Hi All I deal with months and years, week numbers etc. So perhaps I can shed a bit of light. Your 93 or 5 method, i am not sure if this would work in all instances For having the last 6 months i would use all the fields as dates. Where does the "201401" data come from? If I needed to find the...

Thanks for the replys. Its not the WHERE part its the fact no results are returned. As stated originally the NZ function does not work in this instance. I have developed a work around for this where I only use the above query as the record source of the form after I know there is a value to...

Hi The way I fault find this is to use debug.print SQL From the intermediate window I can cut and paste the SQL into a query. Trying to run this query or even to look at the design view helps :) You may find something out of place Hope this helps T

Hi All After spending the day looking for solutions i think i need to ask for help. I have a form that has its recordset generated from SQL. All fine, this form is the available selections to automatically populate another from ( One is generated by the engineer the other by the production...

Forms 7 deep :eek: If i need to go more than the 3 deep then i forget about using a sub form. I dynamically link two subs-forms. So depending on what the record the user clicks on in sub form A - depends on what is viewed in sub form B. Controlled by their common main form. If you get my drift...

The table/column Passive with Yes/No shows as a checkbox in the form. I am guessing that you need to generate a yes over multiple records that correspond to the project that you are working on.

Hi The string ID is passed by the openargs method to the new form and is stored in new form parameter me.openargs. So in the new form you need to assign me.yourfield = me.openargs Yourfield must be a string in this case or it will be the wrong data type (I think) Tim