Search results

I'm rusty and could use help, I have table where First Name, Last Name and Initial are all in one field. What is the syntax to remove initial? Been playing with Right and Len with no success, I'm sure this has been done before.

Need to automate the process of pulling data from a db, but unsure of how to proceed, instead of the typical enter a date or enter a date range, i need to enter up to 7 dates to exclude from a data pull. I understand how to do it in a paramter query, how would this been done on a form? Most...

I'm stuck, i have a rather long iff statement and i can get part of it to work with only two conditions: I understand the logic of it iif(test,True,False) what i need is the iff statement to check a [statefield] for 10 possible matching states, ie. WhatToDo: IIf([statefield]="AL" Or...

I thought I've done this before, searched Nz w/no luck, any who, i have a cross tab query which works correctly, but I want it to return 0 instead of blanks, this is my syntax in a query: expr1: idcardiotype count value

I have member data in table a from two months ago and member data in another table from one month ago. I need to compare the two so i know whom the new ones are, what is the best approach? there are other things i have to constrain on, but that isn't the issue

I have a combobox on a form that looks up info, which works fine, but if the user hits tab, instead of going to the next field the information disappears from the combobox...thinking if i put some code in OnLostFocus and move it to the next field that would fix my problem,....does this sound...

I have BOUND 5 combobox that does a lookup and it works great (it pulls up customer address), problem i just discovered that if the user need to update an address (typo), this can't be done. This makes sense since it's bound. Anyone have any ideas as to a work around? would greatly appreciate it

I have a form w/combobox, if not in list a subform popups and new user information needs to be entered/save which works fine, but i need the a) combobox doesnt requery - but instead I'm stuck in a loop, of do "do you want to reenter", does anyone have a sample of how they got this to work?

Not sure how to do this...any suggestions (I usually create my forms based on table), I need to have a form that pulls from an external db (I can't write to) so it looks up to (customer info) then the user enters info on a form and all the information on the form gets written to many tables, but...

I have a form that uses a listbox with a query to open, which works fine in the switchboard, but doesn't work with the navigation pain....has anyone else had a problem? my select query is: SELECT DISTINCT [tblCompletedby].completedby FROM tblCompletedby; also the form is small in size, (3' x...

being very rusty w/access I'm looking for help. I have a form in which occassionally a user will have to save, the data, refresh the data and duplicate the data w/msg saying you are looking at the duplicate record. I have created 3 command buttons. This seems stupid, i would prefer to have one...

Been away from access for a while; I have a form with a control (listbox, checkbox, combo box) in which I want my user to select multiple items; Initially i have all possibilities coming from a table w/checkbox, but I've it wasn't normalized that way, so i created a tbl call LOB. Now I'm unsure...

creating a db, not using the autonumber and instead using a txtbox w/ =DMax("[Requestnumber]","tblname")+1, which works great! now I need to duplicate a record, using the wizard this works great too, but now I have two of the same requestnumbers. Searched around forum and didn't locate an...

I've read thru the files on this topic and it doesn't seem like anyone has addressed this issue: I'm using Access 2010 and I want to send the form (not report) via pdf preferability) I have a table that stores the email addresses; button on the form which when the user hits is suppose to make...

I've read thru the files on this topic and it doesn't seem like anyone has addressed this issue: I'm using Access 2010 and I want to send the form (not report) via pdf preferability) I have a table that stores the email addresses; button on the form which when the user hits is suppose to make...

can anyone assist? I have a txtbox and the control source is =DMax("[Requestnumber]","tblPMSRequest")+1, which works fine, but now I need to add an alpha character to it, depending on what form is opened. i.e. one form would be coded D, R and G. I've created a textbox on the form made it not...

Not sure how to do this, any suggestions? I have 2 excel files: file A badge # name position file B F/N L/N course name course date Thought I could use access to do this, I need to look up the badge # in file A, a user was qeuerying the last name one at a time (are hundreds, which get uploaded...

I have always used integers or auto numbers as primary and foreign keys. Currently for a school project using oracle and sql plus, I have to code a db the instructions are to make all the pk and fk strings, though it was never explained why, can anyone explain to me why this would be better? is...

I need assistance, the lookup won't work after doing the append, advice? 2 tables Users & Scores Users name, dept & IDStudent (primary autonumber) Scores IDStudent (primary number) w/lookup to users SELECT [ID] AS xyz_ID_xyz, [Dept] & ', ' & [Student Name] AS xyz_DispExpr_xyz, [Dept]...

I have 2 tbls User & Scores, I need to periodically import into these from excel. I suspect I need to import into a table then create an append query...I have autonumber in the user table PK and Scores w/number, will this work? or would this be an update query?