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...

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()...

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 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...

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 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...

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 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...

Hi I was wondering if anybody could help me with this? I have the following code on an on click event for a button If Me.practicecheck.Value Is Null And Me.rolecheck.Value Is Null Then DoCmd.OpenForm "filtered results no role no practice" End If but I get the debug box pop up, and when I go...

Hi I am trying to develop an inventory control database and would really appreciate some advice on the way I propose to develop the application Inventory Control Database. Outline for inventory control database. The database will have the following tables: Supply Table Person Table...

Hi Was wondering if anybody could help me with this? I would like to be able to perform a requery Me.cmbgplistname.Requery everytime a user clicks a navigation button on a form to move through the records? On which event would I place it on? Thanks Marcus

Hi Was hoping that somebody would be able to help me with this. I have a continuous form showing all the records with a button that allows the user to click through and edit a particular record in the list. What I was hoping to do is change the colour of the detail background if a value of a...

Hi I was just wondering which event would I use to make something happen when a user uses the navigation buttons to move between the reocrds on a form. I have written something that basically, validates a form, and I have attached it to the close button on the form, but now want it to also kick...

Hi I was wondering if anybody could help. Up until yesterday, whenever I placed a button on a form a box would popup giving me the option to make the button open a form, a report a query or close the form. For some reason this wizzard has now disappeared and I would really like to get it back...

Hi I was wondering if anybody could help me with this. I have a form with that contains the fields appointment date and appointment time. I would like to know if anybody could help me to create a script that opens up an outlook calendar (if possible be able to select the caledar that is opened...

Hi Was wondering if anybody could help with a select case statement I am using to validate a form This is the code Dim myclinic As String Dim myfname As String myfname = Me.txtFirstName myclinic = Me.frmClinic Select Case myfname Case Is = Null MsgBox "Please enter a first name", vbCritical...

Hi Was wondering if anybody was able to help me with this. I would like to be able to filter records on a form using another form, where the user is able to type in values in order to select the records to display on the other form. I have a number of fields Surname date Clinic post code...