Search results

I have a need to do multiple imports from Excel each week, each import needs to be individually identifiable. Is there a way to create a unique ID for each import I do (as opposed to each record). Thanks.

Hi all, looking for some feedback and advice. I have a Access backend linked to a SharePoint list. I run daily updates from several sources via the Access end to update the lists. One of the updates I run takes well over an hour (sometimes 1.5 hours, depending on the network). What I'd like...

Hi, I've tried to search around for a solution to this as I won't be the first to have asked about it, but I cannot think of a term to clearly define it and what I have searched for doesn't come up with what I'm looking for. We have a Db that holds data on multiple projects (Project A...

Hi all, I need to use the Switch function in a query. I have a query that gets the first letter of a Position Number (D, V, C etc. that works fine). Then, I take that query's results, and use it as a sub query in a second query. I then need to show a value dependant on what is returned...

HI, I have no doubt this is something very straighforward I cannot see, but when I try to comile my Db, I get an error saying; Compile Error: Label not defined. I've checked through, but cannot find the problem, it tells me "Resume Exit_cmdEndAfterCalendar_Click" is the line causing...

Hi, code noobie, so would love some help here. I have a form with several controls (mostly txt and chk). When I click a cmd, I have set some of the controls to Visible = False and some to Visible = True depending on what the user needs to see at the time. What I'd like to do, is if the...

Hi, I have a combo box on a form, but the data in the combo is wider than the object on the form, so some of the details are cut off when you scroll down. What I'm wondering is, can I make the cbo object on the form a smaller size, but when I hit the dropdown arrow, the choices appear in a...

Hi all, I have a form used for a couple of parameter qrys, what I'm trying to do, is hide some objects on the form, but on the On Click of a button, I'd like to make a few more objects visible via VBA. I've tried; me.txtDate visible = true and forms!frmReportParameters!txtDate visible =...

Hi, I have a form for Reports and on it I'd like a dropdown that displays the reports that are available (or maybe queries, I don't know which yet) so users can hit the dropdown, select their report, enter some parameters (just dates) and then I've just got a button that runs the report...

Hi, My db tracks job numbers and who is in them. I have a form with a job number and two options; the 'owner' of the role (substantive occupant) and the 'current' occupant (if someone is on leave, or acting in a second role). I have a cbo to a query based on tblPeople to get the occupant's...

Hi, my db has a view data form frmJobsView. When I am done with a job (the db tracks jobs and workers and manages the status of a job) I would like to open the view job form and have a check box that on update to true, sends that job from the tblJobs to the tblJobsArchive. Does anyone have...