Search results

Hi .. maybe someone can help. I need to pass a range of numbers (0 and 1) as a parameter to a query but I can't seem to get it to work. If I pass just a single number 0 or 1 the query returns the expected result. but If I assign the parameter a range using the vba below the query ignores the...

Hi.. I'm trying to create a reconnection routine for my adp project so that if the network drops the adp project will reconnect when the connection / server becomes responsive again.. One issue I have run into with the adp project is that I need to close the connection using the...

I was hoping someone may be able to help me.. I'm v.new to vba and I'm trying to create a error handler that reconnects the database when it detects the connection has dropped.. I have this working on my main switchboard but having a bit of trouble with a calendar control.. The code is below...

hi all.. I was hoping that someone may be able to point me in the right direction... I have created an adp/sql database & it works a treat. What I get occasionally are the dbnetlib connectionwrite general network error's when for whatever reason the network falls/fails... What I would like to...

hi . I am wondering if it is possible to allow the user to reorder a tab control's pages at run time. Looking at some vb.net code at http://dotnetrix.co.uk/tabcontrol.htm it's possible there just wondering what my options are in access? can anyone make some suggestions..

Hi all.. I was hoping that someone may give me some tips how to handle a subform refresh. here's the background, I have a drive schedule that many people can update, currently if you click on the calendar it refresh's a subform that displays that days info. Thing is unless you click the...

Hi I'm trying to pass a reports record source and input parameters via vba as I have a problem with my reports in my adp project that require parameters from forms. It works fine under my user account but for my users from what I've read adp projects do not append the correct record source...

Hi.. I have the query below setup in my access adp project. It works, ok but rather than have the standard prompts I want the sql stored procedure to use the details from an unbound form. I have the form setup but unsure of the sql code. Does anyone know how to achieve this? SELECT...

Hi .. I'm trying to do something pretty basic (I think) and just wondering if anyone can help me.. I wish to search a remote table (holidays) that contains a list of dates for a date value that is given on my current form.. if its there I wish to lock the subform I have for editing.. but I'm...

Hi I am looking to return a value in a column of my query if the query returns no results, figuring this will need to be done with a stored procedure... does anyone know how to perform this the query i have is shown below that works fine if a job exists, all i wish to do is if no results are...

Hi hoping someone may be able to help.. I'm getting this error on a sql select statement conversion failed when converting varchar '433salisburydelivernjhnj' value to int my sql skills are somewhat basic.. here's what i have Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim s As...

Hi .. I have a few text boxes on my form that I would like to check for duplicates before adding a record.. I managed to cobble the code below togther but think there is a problem in my sql... can anyone suggest a possible solution Dim Rst As Recordset Dim S As String S = Me![ID] & Me![BR] &...

Hi.. I really need some help with my desperate vba skills!. When I click a date on the calendar control on my form a new record is added to the database, this works great. Trouble I have is when I click a date I have already entered I am trying to get the database to retrieve the record and...

Hi.. hoping someone may be able to help What I am attempting to do is create a schedule database for our daily jobs.. My question relates to the calendar active x control. Currently when I click the calendar it updates my job date field and finds the next working day excluding a list of...

I am creating an access 2007 database where i need to calculate the next working day exluding a range of holiday dates from a seperate table. When I add a new record I wish to add the next business date into a date cell. I have managed to achieve this on excel using teh nifty workday function...