Search results for query: *

I am trying to create a number keypad on a form that the end user can use to enter data. The end user will be using a tablet while walking in a department and entering data. The below vb code works but does not work when the end user needs to enter data into a sub form on a tab control. A...

I'd like to use SQL Server 2014 Management Studio and write a SQL statement that returns all the program files on my computer - or better yet another user's computer. But first things first....your help would be appreciated. First I'm trying to list just my machines programs that are installed...

Part of My Code in SQL Server Mgmt Studio as listed below. On the last line I want to get the modified date on the txt file that is used in the bulk insert and place into a column that I just created "UpdateFileDate". Any help on the code I would use? I have end users who creating a txt file...

I want to know if there is a formula that is similar to SUMIF but for text. I want to return text values.... If last year & this year crop is corn (C) then return the field name(s) example.... year year 2010 2011 field crop crop...

I want to repeat this step (copying current record) as many times as the end user states in a text box on the current form. DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdRecordsGoToNew DoCmd.RunCommand acCmdSelectRecord...

I wish to have a cmdbutton (cmdAddNewEntry) disabled when the NextNum = 1 (NextNum is a textbox on the current form) and enabled when NextNum <>1. Below is my code & I am not sure why it keeps locking up on me. Private Sub Form_Current() Do Do While Me.NextNum = 1 If Me.NextNum = 1 Then...

I have a combox box which is bound to a field in a table and selects its list from a querry. After the end user chooses the field - everything works as it should - when using the mouse. If the end user chooses to use the down arrow to select it works - EXCEPT that the screen still shows part...

I don't want the end user to be able to have duplicate records for the same date and shift. (I have a control number as a primary key field due to the large amount of related data - backend in SQL, front in Access) example: date 10/1/10 shift 1 (good) date 10/1/10 shift 2 (good) date 10/1/10...

I want to use a wildcard (?) in an isnumber statment and it is returning an error. cell: a1 = SEWM cell: a2 = isnumber(search("SW",a1) results in false (because SW are not next to each other in cell a1. Help screens suggest I can use wildcard (?) to show any sequence in search text -...

I have a database in Access which uses linked tables from SQL. The security is based on the end users windows login. I do updates to the front end in Access and then update each users computer with a copy of the new dbf. I need the database to update the table links to use the current end...

I have a form in which the end user selects which records they wish to print. They can choose up to 10 records. Each selected record is an unbound text box. The end user then selects a cmd button to print preview. The querry behind the report querries which records are in the unbound text...

I hope I can explain this well enough... I have a worksheet tab called "5 8" (it stands for May8) I have a worksheet tab called "total" I want to reference tab "5 8" inside a formula on the total worksheet. I know I can use ='5 8'!A1 and get the info from the cell (A1) into the total...

I have a database on my laptop for some testing (it is currently being used by many users with no problems on a server). The backend is in SQL 2005. I am the owner/creater of the database but I have placed this file in a folder that all users to this laptop have full access to. When a...

I have a subform on a form (they are linked) and after the end user enters data the focus moves to another subform in which the end user enters more data. After the subform the end user enters data directly onto the form and the focus moves through several other controls & then starts again...

I have an expression in my querry: [number1]\[number2] this number is rounding up & I have the format set to standard with 2 decimals - but I don't want it to round up- how?

I have a subreport on a report. The end user clicks on a cmd button on a form to open the report. The report is based on a query with a date criteria that is on the form. I am also using a function to filter data on 2 separate option button groups. My code is simple: domcd.openreport...

My boss would like to see just the totals for each department/Production area on 1 form. The database is very large & I have 6 subreports that give him the totals (all different headings etc.) It looks great - but when one department's production is longer, I would like the next subreport to...

I am a beginner with SQL and the business that I work for wishes to increase dramatically our Access databases. So....we are wanting to use SQL for backend only. I used the migration assistant (2005) and now all the tables sit in SQL. Everything seems to be working well with the linked...

I have a form in which the end user selects from a unbound list box, then clicks a cmdbutton to preview report. The report is based on a query which uses the list box (on the form) as the Criteria. All works well.... However I also want the end-user to view the report showing all records (no...

I would like to show all records that = a certain text box on a form. the help gives me: Me.Filter = "Country = 'USA'" '(I want this to be a control (text box) on the form) Me.FilterOn = True I want the end user to be able to view all data for a product that is selected on a form. The...