Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 68
Search took 0.17 seconds.
Search: Posts Made By: rywello
Forum: Forms 04-30-2018, 09:14 AM
Replies: 10
Views: 299
Posted By rywello
Re: Help with linking a combobox

Ok, sounds good.

arnelgp : No I did not change the combobox name. Why would I be getting the below error?


Now I am I am getting the error Syntax error (missing Operator) in expression on...
Forum: Forms 04-30-2018, 08:07 AM
Replies: 10
Views: 299
Posted By rywello
Re: Help with linking a combobox

Here it is. I am also trying to get the shift types in each date across kind of like a calendar but not sure if that is possible with these forms. Thanks!
Forum: Forms 04-30-2018, 08:01 AM
Replies: 10
Views: 299
Posted By rywello
Re: Help with linking a combobox

I changed the table name to Employees.


Now I am I am getting the error Syntax error (missing Operator) in expression on the below line:

rs.FindFirst "[EMP_NB] = " & Me.cboEmployee

I...
Forum: Forms 04-30-2018, 06:09 AM
Replies: 10
Views: 299
Posted By rywello
Re: Help with linking a combobox

Thanks! I no longer get the type mismatch or any errors but the subform is not populating. Is Me.tblDays_subform.Form.RecordSource = strSQL correct when referring to the subform?
Forum: Forms 04-30-2018, 05:16 AM
Replies: 10
Views: 299
Posted By rywello
Help with linking a combobox

I have the below code and to link a subform and a form based on the combobox value. I get a data type mismatch on the code highlighted in orange. It is a number field so I am not sure why the...
Forum: Modules & VBA 06-10-2016, 11:43 AM
Replies: 13
Views: 292
Posted By rywello
Re: Issue with Select Statement

Hi Again, I have tried adding on to my select statement but I am getting the error "Too few parameters. Expected 2. I am trying to pull the records that have a PIGIDATE equal to today's date or 1 day...
Forum: General 06-09-2016, 01:44 PM
Replies: 4
Views: 345
Posted By rywello
Forum: General 06-09-2016, 01:29 PM
Replies: 4
Views: 345
Posted By rywello
Forum: General 06-09-2016, 12:58 PM
Replies: 4
Views: 345
Posted By rywello
Multiple html tables in Outlook email merging together into one.

Hi Everyone,

I am trying to create an html formatted table in Outlook that displays the results of a query. I can get the 2 tables to display on the email but they merge together into one. I also...
Forum: Modules & VBA 06-06-2016, 04:27 PM
Replies: 13
Views: 292
Posted By rywello
Re: Issue with Select Statement

I used the statement with the "OR" instead of "AND". Thanks again!
Forum: Modules & VBA 06-06-2016, 04:20 PM
Replies: 13
Views: 292
Posted By rywello
Re: Issue with Select Statement

That works great! Thanks!
Forum: Modules & VBA 06-06-2016, 04:12 PM
Replies: 13
Views: 292
Posted By rywello
Re: Issue with Select Statement

I want to bring back all the records for the plants 00CX and 01FT.
Forum: Modules & VBA 06-06-2016, 04:11 PM
Replies: 13
Views: 292
Posted By rywello
Re: Issue with Select Statement

I got the first part of the select statement to work and bring back all the records for 00CX so I tried adding on to it.

strSQL = "SELECT * FROM tblTrucks WHERE [Plant] = '" & "00CX" & "'"
Forum: Modules & VBA 06-06-2016, 03:50 PM
Replies: 13
Views: 292
Posted By rywello
Issue with Select Statement

I am writing a select statement to bring back the data for two plants 00BB and 01FT from the tblTrucks table, Plant column. The below query only brings back the data for 00BB but nothing for 01FT....
Forum: Queries 05-13-2016, 09:14 AM
Replies: 10
Views: 650
Posted By rywello
Re: strWhere Error

That works! thanks,
Forum: Queries 05-12-2016, 07:33 AM
Replies: 10
Views: 650
Posted By rywello
Re: strWhere Error

I can not use a validation rule as I import the table into my database and it won't allow me to save the validation rule on the field. Is there a way that I can add it to the VBA code I listed...
Forum: Queries 05-05-2016, 11:25 AM
Replies: 10
Views: 650
Posted By rywello
Re: strWhere Error

I have the code on the on click event of a button. I still cannot get the validation to work.
Forum: Queries 05-05-2016, 09:47 AM
Replies: 10
Views: 650
Posted By rywello
Re: strWhere Error

What do you mean "before update"?
Forum: Queries 05-05-2016, 09:00 AM
Replies: 10
Views: 650
Posted By rywello
Re: strWhere Error

Sorry, I was just giving an example. My code is really:

If Not IsNull(Me.nomkey) Then
strWhere = strWhere & "([Nom Key] = " & Me.nomkey & ") AND "
Forum: Queries 05-05-2016, 08:23 AM
Replies: 10
Views: 650
Posted By rywello
strWhere Error

I am using the below code to search in a number field. When I enter text in the field, it asks for a parameter value before throwing an error. How can I get it to throw an error that says "Please...
Forum: Queries 04-05-2016, 06:25 AM
Replies: 9
Views: 482
Posted By rywello
Re: Pulling a month from a text string

I get a Func! error on 1 992522 OP and a #Num! error on 1 12507016300. It works with the original code.
Forum: Queries 04-04-2016, 09:29 AM
Replies: 9
Views: 482
Posted By rywello
Re: Pulling a month from a text string

I am still getting errors on some of the fields that should come back with the month value.
Forum: Queries 04-04-2016, 08:44 AM
Replies: 9
Views: 482
Posted By rywello
Re: Pulling a month from a text string

Is there a way to make it do nothing if there is no number to pull the month from instead of it showing an error? Thanks
Forum: Modules & VBA 03-23-2016, 06:40 AM
Replies: 18
Views: 1,102
Posted By rywello
Forum: Modules & VBA 03-23-2016, 03:48 AM
Replies: 18
Views: 1,102
Posted By rywello
Re: Referring to a listbox from Main form in a module

I still get the same error when I concatenate the empty column to an empty string.
Showing results 1 to 25 of 68

 
Forum Jump



All times are GMT -8. The time now is 05:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World