Search results
-
T
Select a certain record from a listbox
Ok update.. I figured out what that parameter value was... it wanted literally the ID number so on a test I changed DoCmd.RunSQL "Delete * from tblpublisher Where ID=" & Me.addpub_publist to DoCmd.RunSQL "Delete * from tblpublisher Where ID=" & Me.addpub_publist DoCmd.RunSQL "Delete * from... -
T
Select a certain record from a listbox
I edited this line: If MsgBox("Are you sure you want to remove '" & Me.addpub_publist.Column(1) & "' from the list?", vbYesNo + to remove the .column(1) and now it asks if I want to delete the correct thing but it still throws up an enter parameter value box which Im unsure what that is -
T
Select a certain record from a listbox
lets see what I had pop up first was this: When the warning screen popped up I got Are you sure you want to remove " from the list? I would click yes even though it didnt tell me what I wanted to delete, it would then pop up a Enter Parameter Value box and would show the value that I wanted... -
T
Select a certain record from a listbox
ok Ill try that on the delete... I was doing this and got all sorts of errors Private Sub Command32_Click() If IsNull(Me.addpub_publist) Then MsgBox "Please select a record from the list to delete", vbCritical Else DoCmd.SetWarnings False If MsgBox("Are you sure you want to remove '" &... -
T
Select a certain record from a listbox
Ok I have 2 questions, hopefully easy ones :) Im pretty new to access, used excel for pretty much everything up till now so I think on flat terms generally but Im trying to force myself to think outside of the box now and learn access... finally. Anyway Im making a form that will consist of... -
T
A few questions on the setup of my database
is there a major advantage in efficiency between macro and code? I mean if its something major Ill put in the time and effort to learn how to code properly but if they are about the same Ill do whats easier for me now Also... do spaces matter at all? most examples ive seen call tables... -
T
A few questions on the setup of my database
Thank you :) out of curiosity I was looking at a neat site that was giving some tips on things I coudl do... one of them was linking 2 combo boxes would allow me to set it up so I could set a form that would allow me to have 1 combo box or list box that would have the publishers, and a second... -
T
A few questions on the setup of my database
I wrote it out like I did in all that verbiage so people would know exactly what I was doing... in my experience in helping people with excel they write their question and no one understands what they are doing so they ask them to elaborate then they end up writing out all that verbiage anyway... -
T
A few questions on the setup of my database
sorry about question 3... I apparently had my stupid hat on, Ill just set up a 1 to 1 relationship and that should do it, or at least in theory since Ive never actually done it before ... as I said I know theory not practice yet -
T
A few questions on the setup of my database
Hello, some background before my question… I’ve been a long time excel user, I’ve always found a reason to go to excel when I probably should have been using access. So I have a tendency to think in flat single table methods…Well I’m trying to come out of my shell per say and I figured I would...