Search results

Hi, Thanks. I'm not very good with VBA, are you suggesting something like this: DoCmd.OutputTo acOutputQuery, "SELECT FROM MarkGrid Full_Name, Form, CW Effort, HW Effort, KS3GRADE, Test Mark, Course_ID, Class_Teacher, Unit WHERE (Mark Grid.Form = Forms.Courses.Combo28 AND MarkGrid.Unit =...

The data displayed on form 2 is determined by; (1) the WHERE condition of the code

qry_mark_grid uses criteria (filtering) from a combobox from the previous form. So I am selecting a values from a comobox on form 1. On the click event I am using VBA code: DoCmd.OpenForm "Mark Grid", , , "[Form] = '" & Me![Combo28] & "' AND [Unit]= '" & Me![Unit] & "'" Form 2 displays the...

From a query. I have started looking at this VBA code, but it exports everything. DoCmd.OutputTo acOutputQuery, "qry_mark_grid", acFormatXLS, "MarkGrid(Class).xls", True

Hi, I have a filter on a form using a combobox. I want to export the data displayed to an Excel Spreadsheet. I have used the Exportwithformatting Macro but it seems to export everything. Thanks

thank you!

Hi! OK, I have two forms: Form 1: Courses Form 2: Mark Grid The user select the class from [Combo28] for the unit already in [Textbox named Unit] from Form 1 and wants to list all the students for that particular class and unit in form 2. I have tried god knows how many different codes...

^ Thanks. I was actually trying to use conditional formatting to avoid coding.I have found another way round it :D.

Hello All. I am an absolute beginner to Macros so please consider this when replying :D I need to create a macro which simply checks whether the username and password entered on the form matches the one in a table in the database. If it matches then it takes you to a specified form otherwise...

Anyone out there that can help me? :confused:

I have a date field on my form and i want to use this to look up a list of booking dates. I have created a command button and used the operations wizard to look up values on a bookings form. when i enter a date with day (01-09) e.g. 05/08/05 it doesn't look up any records although these exist...

Hi all, With some help from this forum (esp. Pat Hartman), i've been able to code up a script that performs a check on duplicate values. My database has a Room Bookings form which consists of the room name, periods and booking date (BDate) fields. I need to prevent a duplicate on the same...

Pat or anyone ? any suggestions on how to resolve the above? :confused: :(

Thank you Pat, That worked! The only thing is that everytime I enter the same booking date although i select a different period it still comes up with an error message saying that booking already exists? This means it only works on 1 field which is the BDate field. how can I change the query so...

Do you mean like this? strSearch = "BDate = #" & Me.BDate & "#" And Period1 = """ & Me.Period1 & """"" I dont know, I was just trying different ways to get rid of the data type mismatch error i think. I'm pretty new to VB programming and just working through scripts i find on the net. Please...

Hi everyone, This is my first post! So I hope you will be able to help me! I am using this bit of code on the beforeupdate event of my form. I am recieveing an error message 'data type mismatch' and i think this is due to a date field. Can any1 provide some input on how I can overcome this...