Search results

Hi I was wondering if anybody could help me with this one I have setup a stored procedure that seems to work ok, however it does not appear to be filtering the dates correctly and i am getting back nulls when i enter some dates that i know should return values SELECT DISTINCT...

thanks will try that, i just wanted it to be one tick for whole table

Hi Was wondering if anybody could help me with this. I have a Continuos form with a each record havin a checkbox. I would like to find a way that only one of those checkboxes can be ticked on the form at any one time. Thanks Marcus

Hi Was wondering if anybody could help me I have manually imported a text file to Access with field names. This works fine. I then delete the contents of the table that i have created via the import and tried to re import the data to this table using a bit of code Sub importme()...

thanks for that

Hi was wondering if anybody could help me with this I have the following piece of code DoCmd.RunSQL "INSERT INTO dbo_TblFileLoaded (PracticeCode, ExtractID) VALUES (sPractice,sExtract)", -1 sPractice,sExtract are variables that i have declared earlier in the code. However, when i run this...

Hi I have the following problem I have written a script that i want to loop through a recordset. Everytime the script finds a blank in the firstname column, to take the value of the previous firstname and populate it with that, but the script does not appear to be working can anybody help me...

Hi When i recieve the extract it comes without the person ID on each line, so i am just trying to work out the best way of doing that, How would i go about doing this using a recordset as you suggested? Thanks Marcus

Hi I am hoping that somebody could help me find a solution to a problem i am having importing data from an excel spreadsheet to Access then transforming that data using VBA. The data in the excel spreadsheet comings a a strange format. Basically, instead of having different spreadsheets for...

Hi Was wondering if anybody can help with this I would like to create a view/stored procedure whereby i can delete the contents of multiple tables in one view something like this delete from table_a delete from table_b this does not appear to work and i was wondering if anybody could please...

Thanks will give these ideas a try

Hi Bob Thats what I was thinking too. Do you have any idea on how to automate this in SQL using either a DTS package or stored procedure>?

Hi I was wondering if anybody could help me with this. I have a Database in SQL server, which is quite large with approx 300 tables. This database is a static database and in order to get the most upto date information I can download the database and recieve it as a zip file with an Access...

Hi Rural Guy Have managed to get it working with before update event now, i had to remove docmd.gotorecord acnew..... from the onopen event thanks marcus

Hi I was wondering if anybody could help with this. I have searched through this forum and there doesnt seem to be an answer to this. I have a form that i would like to validate. At present i have put the data validation on the save button which triggers a script that checks to see if...

Many thanks, will try this out

Hi I was wondering if anybody could help with this? I am trying to create a textfile with code in it when a user clicks a button in an access form Dim fso, myfile, fileText Set fso = CreateObject("scripting.filesystemobject") Set myfile = fso.createtextfile("c:\testfile.txt", True) fileText...

Hi I have had a quick try, here is the SQL code SELECT WaitingCrossTab.RegID, WaitingCrossTab.APPTDate, WaitingCrossTab.DeferredApptDate, WaitingCrossTab.GPLetterDate, WaitingCrossTab.DateAppointment, WaitingCrossTab.WaitingTimes, WaitingCrossTab.Outcome, WaitingCrossTab.Clinic...

Hi Shane Thanks for that Yes, that is what I have been trying to do. Can I use an if else statement in a query criteria? Thanks Marcus

Hi was wondering if anybody could help me with this. I have a report that is based on a query. The query filters the records by textboxes on a form. At the moment I am filtering one of the date fields like so >=[Forms]![ReportsMenu]![txtstartdate] And <=[Forms]![ReportsMenu]![txtenddate] But...