Search results

hi all, still very much learning to use VBA, so any help would be appreciated. I have a sheet called "Overview", Sheet1, sheet2. "Overview" column A is a list of names. I want each name in the list to mirror cell A1 in each sheet. eg Overview A1 = Sheet1 A1 Overview A2 = Sheet2 A1 and so on...

would the variable be string?

really sorry I'm still quite new to access - learning as I go, how would I put that into this?? Dim db As DAO.Database Dim rs1 As DAO.Recordset Dim rs2 As DAO.Recordset2 Set db = CurrentDb Set rs1 = db.OpenRecordset("tblFixtures")...

sorry to sound stupid where would up put that in the current code I have written?

Hi All, not sure if this is even possible, by any help would be appreciated. I have a form which opens 2 recordsets. the first RS1 adds a new record the second - RS2 needs to add the ID of the new RS1 record, hope that makes sense eg. rs1.AddNew rs1!AgeGroup =...

hi all. I have a code that works fine if the field in the table is a short txt field, however I need the field to be a number field, and therefore the code doesn't work. the code I'm using is If Not IsNull(DLookup("[SquadNumber]", "tblPlayers", "[Squadnumber] = '" & Me!SquadNumber &...

would I still need For Each varItem In ctl.listcount ..... next ??

hi all. I'm struggling with what is probably a very simple solution, and would like some help. I have managed to amend records based on the user selecting multiple items in a list box by using the following code. Set db = CurrentDb() Set rs1 = db.OpenRecordset("Usage"...

Hi all, fairly new to access and still learning a lot. I need a textbox to display the first/earliest date from a table. the table is called tblIncidents and the textbox is txtFirstDate I've considered a variable and tried with querys etc. any ideas, appreciate any help...

Hi all. Apologies if there is a really simple solution. I have a query and need it to filter between to dates that are entered into a form. the dates are long date fields (dd/dd/dd hh/mm/ss) I've used the following search criteria Between #" &...

Gizmo. Sorry to sound thick, but I don't understand what you mean. Appreciate your help.

I did consider this, but I'm a fair way through the database, and a lot of the info/queries now rely on seperate fields. So is it possible?? Sorry to be a pain. Thanks

Yes that's correct.

Hi All, Apologies if this has already been answered in another thread, but couldn't find anything. I have a table which list a load of items, one field is date and one field is time. I have a form with two date boxes and two time boxes, the idea is for the user to search between the...

Hi all. Would appreciate any help possible, for what I would guess to be a simple question to the right person. I have a table with a list of records, each record has a time From this I have a query, what I would like the query to do, is group the records in the query by hours. Firstly is...

I have two table. Table 1 (assets) list all my assets etc. Table 2 lists all servicing for each asset. I have a form which generates a list box of items that require servicing (once servicing has been completed on these items) it update all records, in both tables. Table 2 with all the...

I need to put in 3 different variations of this loop, and depending on what the user selects from a list box will depends on which loop is ran. what I was thinking, is if I could put each of the loop into a variable, I could then run a if statement. does that make more sense?

hi. Please help, I am relatively new to VBA and have this loop (see below) was wondering if it was possible to build it into a variable, so I could call upon it within an IF statement. pleas forgive me, if I am completely talking nonsense. thanks Mark Set ctl =...

That's what I thought and tried initially, but just couldn't seem to get the code right.

Galaxiom, what would you suggest instead of using dlookup?!